How-to Question: combo box, insert primary key

[dlittman]

I have a MySQL DB with several tables, linked by standard PK/FK relationships.

This is an interactive DB to which users quite regularly add records through forms.

When a record is added, I want to store the key, rather than the value, in the new record (to preserve the PK/FK structure.)

So, I would like to have a combo box that
1. goes to the DB and populates the combo box with the values the user could select (say the name of the particular product just sold) but
2. Stores the key for that value in the new record.

Can someone please help me with this?

Thanks very much.

dlittman

[devinemke]

Originally posted by dlittman
So, I would like to have a combo box that
1. goes to the DB and populates the combo box with the values the user could select (say the name of the particular product just sold)

i assume then that the target field in the db is an enum type? if so then just do a DESCRIBE query on that table. the returned result will have the possible choices for the enum which can then be loaded into an array and looped through to create your combo box.