var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Multiple Record Entry
I have two tables
I am trying to insert multiple records into table 2 from a form. Is there a way to do this? example would be a form for a Flight event
Where EventTypeDetailID = DepartureCity EventTypeDetailValue = City Name
Where EventTypeDetailID = DepartureDate EventTypeDetailValue = Date
and so on.. for Arrival City, ArrivalDate, Flight Number, SeatNumber
All this would be store in the TripEventTypeDetails for each type of event.
Right now I have a Main Form(Table1) linked to a Continous SubForm(Table2) where I can input the many details as necessary.
Is there an alternative?
What is the PRIMARY KEY in your tables, (Don't put the different data in one field, learn something about DATABASE NORMALIZATION, DOMAIN).