AnsweredAssumed Answered

Enter data from the 1 table in the many table

Question asked by fmnoob on Nov 22, 2014
Latest reply on Nov 23, 2014 by fmnoob

Title

Enter data from the 1 table in the many table

Post

I have 2 tables:

1 Table                    Many Table

ID                              ID

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.

Thanks

Outcomes