Wrong information going into table from form

[bespra]

I have the combo boxes working correctly but the information does not input into the tables. It is putting the id numbers in instead. I would also like to make it so that users can see the data tables after the data has been input and edit if necessary. I am fairly new at this.

[June7]

Saving only the selected ID value is correct behavior for relational database. This is the purpose of primary/foreign key linking, to relate records on a unique ID value.

Users should not work directly with tables and queries. Build forms as interface for data entry and editing.