Adding more than one field using EDITABLE DROPDOWN
IS it possible to add more than one field to a table using the editable dropdown widget?
I have a field on a form that adds the order person to an order, and the current dropdown list is populated from an ORDER PERSON table that gets its entries using a field that stores the customer number.
When I add a new one to the order, I want it to not just store the persons name in the ORDER PERSON table, but also the current customer number, so that the next time the customer orders, they will have the new order person show up on the new drop down list.
I know it sounds confusing, but basically I just need to store 2 fields, not just one, when I use the ADD button to add a person to the list.
ANY IDEAS? The only post I have seen on this was not answered and is over a year old.
Thanks,
Neil
|