Forms - Drop Down Boxes

[terry]

I have a form and one field has a drop down box with several fields in it. I can only currently get the drop down box to save one field value. Is it possible to get 2 or more fields to be saved when I select from the drop down box? If so, how can this be done and is there a way to be selective about storing specific fields.

 

[icemonster]

yes, on the table field where the drop down box is, make sure you set it to combo list and allow multiple values.

 

[terry]

Hi,
I have the table field as a Combo. I am not sure how you set it to allow multiple values in the properties box.
I am viewing the table field in a form and the form will only save one field into the table, whereas I would like to include other fields.

 

[icemonster]

you can set it from the table properties, when you set it to combo, on the table properties or even the field properties, look for something that says "allow multiple values"

 

[SOS]

you can set it from the table properties, when you set it to combo, on the table properties or even the field properties, look for something that says "allow multiple values"

That is NOT the solution for this.

Actually, if you have data selected from some other source you should ONLY be storing the ID of the item in the other table and NOT the rest of the details.

Bob Larson has this sample on his website which might help illustrate.

 

[terry]

Many thanks for that Smeghead, I have got it up and running.

Terry