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

Hi Neil,

I haven´t tried this yet, but IMO this should be possible by concatenating multiple columns in the query (CONCAT) and have the editable dropdown´s *label* field echo the CONCAT´s "alias" column.

Cheers,
Günter Schenk
Adobe Community Expert, Dreamweaver

Hey Gunter ( I cant seem to find the 2 dots over the U needed for your name!)

Anyway... I dont want to display multiple fields ...when the person clicks ADD I want to load up 2 fields... the person's name, and the company ID. Currently adding, or Editing the list only adds one field.

Am I missing something?

Thanks,
Neil

I'm thinking the insert record transaction that is being created when you click the add button is only set up to add one field. Anything more seems like it may have to be hacked somehow.

I still may be wrong, and I hope so... but thats what it looks like since the insert transaction doesnt seem to be visible in the page code.

Neil