
June 8th, 2009, 10:17 PM
|
|
Registered User
|
|
Join Date: Jun 2009
Posts: 4
Time spent in forums: 10 m 7 sec
Reputation Power: 0
|
|
|
Multiple Record Entry
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.
|