I'm trying to represent the following relatio...

(Jonathan Lutz) #1

I’m trying to represent the following relationship & am unsure how to in AppSheet.

Essentially, I have a table of Customers, Addresses, & Jobs.

Customers can have multiple addresses, and a job is for one customer at one of the customer’s addresses.

Is there any way in AppSheet to define the ref column for the Address on the Job table to restrict selection to only Addresses that belong to the selected Customer for that job?

I can’t seem to figure it out.

(Aleksi Alkio) #2

So… I’m assuming that your Customer column in Jobs table is a ref type. SELECT(Addresses[KeyColumn],[Customer]=[_THISROW].[Customer])