markymark71
New member
- Local time
- Today, 20:20
- Joined
- Mar 11, 2015
- Messages
- 5
Hiya, I am trying to build a database for an entertainments agency.
I have 4 tables created. Agency Table, Act Table, Venues Table & a Bookings Table.
The Agents Table as a primary key called AgencyID which is linked to a field in the Acts Table called AgencyID which is a foreign key.The venues Table is also linked to the Agents Table with a field called AgencyID also a foriegn key.
I have created a form form to input information for new acts...Because an act is managed by an agent i want a combobox that displays a list of agents and then links that selection to the AgencyID field in the Acts Table. I also require the same for the Venues Table as each venue as an agent.
Mark
I have 4 tables created. Agency Table, Act Table, Venues Table & a Bookings Table.
The Agents Table as a primary key called AgencyID which is linked to a field in the Acts Table called AgencyID which is a foreign key.The venues Table is also linked to the Agents Table with a field called AgencyID also a foriegn key.
I have created a form form to input information for new acts...Because an act is managed by an agent i want a combobox that displays a list of agents and then links that selection to the AgencyID field in the Acts Table. I also require the same for the Venues Table as each venue as an agent.
Mark
