Add to Muliple Tables
Posted: Mon Mar 23, 2009 5:44 pm
Hi All:
Here is my issue: I will have the following tables:
Venue:
ID | Name | Demographics
Venue Type:
ID | Title|
Venue by Type:
Venue ID | Venue Type ID
My question is if I have form used to enter enter a venue with muliplte venue types (check boxes), what is the theory behind adding adding info to the Venue by Type Table?
As it stands now, I only have 2 tables, Venue and Venue Type, but I can only have a one to one match.
Here is my issue: I will have the following tables:
Venue:
ID | Name | Demographics
Venue Type:
ID | Title|
Venue by Type:
Venue ID | Venue Type ID
My question is if I have form used to enter enter a venue with muliplte venue types (check boxes), what is the theory behind adding adding info to the Venue by Type Table?
As it stands now, I only have 2 tables, Venue and Venue Type, but I can only have a one to one match.