Enter data from the 1 table in the many table
I have 2 tables:
1 Table Many Table
Name OneTable ID
There is a 1 to many relationship between the tables using the ID to OneTableID fields.
When I enter data in the Many table I want to be able to add data from the 1 table entering a Name rather than the ID. How do I go about setting this up? Using the Name field as the linking field would not be a good idea.