I have two tables
Table1(
TripEventTypes)
- TripEventyTypeID
-
EventTypeID
Table2(
TripEventTypeDetails)
- TripEventTypeID
-
EventTypeDetailID
-
EventTypeDetailValue
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.