On the data side:
I am building a database that includes hotel information for generating job tickets for service calls. Each hotel has 2-3 ballrooms and 2-3 hotel contacts.
On the data extraction side:
In a different layout, I need to generate a service ticket for a specific hotel. I want the option of a pop-up value list to display the related ballrooms (so that we may designate which ballroom) and another value list to display the related hotel contacts (so that we may designate which hotel contact).
This is what I have done:
On the data side:
I designed a form to enter the hotel data. For the