I’m creating a new member signup form for which one of the table entries is a linked record.
The data relationship is as follows:
New member has a linked field to Campus Building, which is a table with (among other things) Building Code (primary key)...
I have two tables, one that is built in-house (say, INTERNAL) and one that is supplied externally (say, EXTERNAL).
I don’t trust my external data source, so what I want to do is find all records present in INTERNAL and missing from EXTERNAL.
If I wer...
Here’s some further information:
Here’s what the form looks like now:
When I expand “Campus Building”, here’s what I get:
I don’t want to display “BSB” here, but rather the associated building’s name “Behavioral Sciences Building”; likewise, I don’t...
@Jeremy_Oglesby
The why of our use case is essentially that we are a labor union. So we have two different rosters of members, one that we maintain in-house and one we get from the employer. We don’t trust the employer’s list, so we need to find memb...
@Mohamed_Swellam I tried what you suggested and it’s not telling me what I want to know.
What I want to know is: which records (by primary key) are present in Table 1, but not Table 2.
I created the linked field as suggested, but the linked field did...
