View Full Version : Storing combo box data to tables


Data Slave
03-01-2000, 06:28 AM
i'm having a problem storing the data from my combo box onto the appropriate table. which property is this on the list of properties for the combo box? right now it is storing the autonumber(ID#) instead of the name associate with the number. does this have to do with the row source? i need to fix this in order to print reports and store the data on tables more easily. thanks for your time & help.
Data Slave.

Pat Hartman
03-01-2000, 03:26 PM
No, you really should store the ID#. To display the descritption in a query, add the lookup table and create a left join to it. Then select the description field.