4 Replies Latest reply on Nov 23, 2014 10:18 AM by fmnoob

    Enter data from the 1 table in the many table

    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