Ok, two questions. I get the logic, I just do...

references
(Joseph Pentheroudakis) #1

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)

My questions:

(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?

Thank you!

(Aleksi Alkio) #2

(1) [Number].[Name] (2) Add a show field (text field) with the formula [Number].[Delinquent] The number field on your Log table has to be a ref field.

(Joseph Pentheroudakis) #3

@Aleksi_Alkio worked beautifully, thank you!

(Aleksi Alkio) #4

You’re welcome