General information
Category:
Database DAO/RDO/ODBC/ADO
I appreciate your help Eric, but I think Ive done a poor job of explaining myself. Let me try this again from the start.
I have an Access database with 2 tables. Table 1 is the primary table and stores the users entries. Table 2 is propulated with data I have entered (a lengthy descriptive field) The end user does not have access to table 2. Each table has an auto-generated record number field. When the user is adding or editing a record for table 1, they have a combo list box (populated by the contents of table 2), from which to choose an entry. The auto-generated record number is stored in table 1, to identify the record in table 2 for that entry. What I am having trouble with, is when the user goes to edit a record, I am trying to display the correct entry from table 2.
Any suggestions?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only