3 tables: Account, JobSite, Job. JobSites r...

references
(Eric Schwartz) #1

3 tables: Account, JobSite,

Job.

JobSites reference Account. Job references Account and JobSites. How to create a dropdown on Job.JobSites, listing only JobSites matching Job.Account? Thanks :slight_smile:

(Bellave Jayaram) #2

Select(Jobsites[key], [Account]=[_THISROW].[Account])

(Eric Schwartz) #3

@Bellave_Jayaram Much thanks :slight_smile: