You folks are so helpful... but here is one I'm stumped on.
I have a database called scrap. It tracks product that has been manufactured but rejected.
The form to enter this information is fairly straight forward, but I'm trying to make it as fool-proof as possible.
The form uses three lookup boxes. The first inserts a customer ID from the customer database.
The second is dependent on the first and allows the user to select only a parts ID... based on the customer ID, from the parts database.
These two work flawlessly.
The third is the one giving me trouble. I want it to list production dates based on the parts ID and give the user a selection of dates to be used as production ID in the scrap database.
phpRunner pulls the correct available production dates accurately, and in the TEST mode does so in descending order. However, when the page is built the control actually pulls the lookups in ascending order.
What the heck am I doing wrong here?
Thanks,
Jake