AnsweredAssumed Answered

Displaying data from one field depending on the data from another

Question asked by DaveHardings on Jun 8, 2013
Latest reply on Jun 10, 2013 by GuyStevens

Title

Displaying data from one field depending on the data from another

Post

     Hi,

     I have two tables: Table 1 & Table 2.  Each has a unique serial ID field and Table 2 has a foreign key field.  They are related by Table 1's serial ID and Table 2's foreign key field.

     Table 1 has a Site Name.  Table 2 has a Group Name and Site Name field.  When I enter data into Table 2's Site Name field, I need the Group Name to display on Table 1 IF the Site Name in Table 2 matches the Site Name in Table 1.

     I'm still very new to this program, so any help would be appreciated!

Outcomes