I have a client who wants to set up a work order. Basically, my issue is how to make the following chain of cascading combo boxes:
Supplier>Manufacturer>Color/Style>Price
There are a number of variables involved. The manufacturer is ALSO dependent on the type of material. For example, there's a list for siding, for shingles, for flashing, etc. I suppose my question (for now) is: is it possible for one combo box list to populate a number of other lists?
Another X factor: I'm trying to keep away from Javascript because the client wishes to change/update the list of suppliers, supplies, and prices every month, so I would like it to be fairly user friendly to do so.
But regarding your comment about keeping away from JavaScript - that might limit your options. If you want to make it user friendly for subsequent updates, maybe you should consider building in a wizard. There's some really great stuff on the Windjack website - eg. the AcroDialog section, where they show an example of how to build a wizard... http://www.windjack.com/products/acrodialogs.php
There's other great stuff on there too.
Meanwhile, I'll wait with baited breath for someone to save us both with a solution to the cascading boxes problem - if I don't figure it out myself in the meantime. If I do, I'll be happy to share.
from way... underground at Parkes - central West NSW - Australia