Displaying data from one field depending on the data from another
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!