Noah_Glaser - profile

Noah_Glaser · Apr 07, 2020

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)...

Noah_Glaser · Mar 05, 2020

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...

Noah_Glaser · Apr 08, 2020

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...

Noah_Glaser · Mar 06, 2020

@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...

Noah_Glaser · Mar 06, 2020

@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...

User Statistics

User Activity

Linked field in a form: display as different column?

Finding entries in one table but not another: emulate an outer join?

Re: Linked field in a form: display as different column?

Re: Finding entries in one table but not another: emulate an outer join?

Re: Finding entries in one table but not another: emulate an outer join?