Hi I've a database with a form that users enter data in, there are various comboboxes that contain the text element from other tables.
everything about the case is store in two main tables.
tblcase and tblreview these have numbered references to the data in the tables that the comboboxes relate to.
How on earth do I tell the database that the numbered value in the relevant field of tblcase/tblreview is equal to the text string in the combobox. At the minute it keeps say #name? or saying the value entered is not allowed.