First of all, LOVE this site. I've learned so much.
I've read tons of threads on cascading lists, but I'm failing miserably. I am creating a quotation form, and have many different sections that will feature cascading list boxes.
First section is customer info. If I select from a drop-down box the customer's name, I want to populate the address, acct number, email, name, phone, fax, etc.
I setup according to guidelines on here, but when I preview the form and select the customer's name, nothing happens.
Second section is the items/quote section. I want to select a vendor, which will then allow me to select their part number in the second box, and then in the third box the description fills in automatically, as well as unit of measure and distributor cost in a field off to the side from which markup calculations will be made.
Thus far, I am 0% successful. I don't mind posting a link to the document, but I need some serious help, and I really need to learn how to do this. If I can pull this off, then I have quite a few more forms I'd like to design to do the same. Also would like (long term) to set these up for web interface...