Ok, two questions. I get the logic, I just don’t know the syntax.
I have two tables, ‘Members’ and ‘Log’. ‘Members’ is a read-only table with three columns, Name, Number and Delinquent (this is yes/no). The Number column is the Key. Numbers are unique.
(EDIT: Googled it and found this, so I’m going to take that for a spin: https://appsheethelp.zendesk.com/hc/en-us/articles/205319178-References-between-tables)
(1) Our ferry operator records members in the Log table as they board the boat. The operator enters the member’s number, and once they do that I want to grab and display the Name associated with that number from the Members table. Syntax?
(2) I want to check if that member is delinquent. So I want to grab the value of the Delinquent column associated with that number on the Members table and display it. Syntax?