Hi, First I'll tell you what I'm trying to do: I'm trying to make an online order form that my clients can download (as an excel sheet) and type in their order, then email back to me. Now, I'm using a spreadsheet format that is supposed to be idiot-proof so that the customers only have to enter the product code into the order form, then type in the quantity of that particular product they want as well as their personal information and no other need to fill in anything else - it'll be automatic.
I've built a database of all of my products but I'm having trouble getting DGET to grab from it. I'm getting an ERROR 518. What I'm trying to do is have the customer type in the code and have an automatic fill on the Type, Flavor, and Price fields of the order form. The code fields in the order form are vertical, and the Type, Flavor and Price fields are horizontal to the code fields. I didn't want to have the database on the same page as the order form, so I put it on an attached sheet of the spreadsheet; does this cause part of my problem? I'm starting to get frustrated by this and that takes a lot. If you know of another way to do this I'd be pleased to give it a try. If you know what I'm doing wrong, please let me know that too. If there is a way around that error, then that would be great news. I'll still keep messing with it, but I think I've done about as much damage as I can take. Two other things that I would like to do: have the sheet automatically date the order form when the customer opens it, and have it create a order number automatically. Any ideas? Thanks for your time. I really love your software, too! Ron Gulette www.montanafudgeworks.net
