I’m very new to this platform and I am looking for help on an issue I have run into. I have what I thought was a fairly simple lookup question, but I am struggling to get it working.
I have three tables:
The Agency Table is setup as follows:
Agency Name: Text (Display Column)
The Venue Table is setup as follows:
Venue Name: Text (Display Column)
Agency Name: Text
The Appointment Table is setup as follows:
Appointment ID (Display Column)
Agency Name: Lookup Table
Venue Name: Lookup Table
The issue I am having is with the Venue Name field in the Appointment table. I would like to lookup the venues as they relate to the Agency Name. For example, if I select Coca-Cola from the Agency Name column, I would like to restrict the venues to only those that belong to Coca-Cola.
Any assistance to this would be appreciated.