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.

why do you need to insert record while you can relate the two tables to get the information or you can use UNION QUERY.

well when they are booking a taxi it would look something like this in table 2.


The big problem I am having is the fact that in table 2 when I open it up in datasheet view the records are displayed like this:



EventTypeDetailsID EventTypeID EventTypeDetailsName Value

1 1 PickUpDate 01/01/09

2 1 PickUpLocation NYC

3 1 DropOffDate 01/02/09

4 1 DropOffLocation Boston
5 1 CabNum 3456



Where EventType is Taxi Ride



Is there anyway to edit these records on a single form without using a continous form. I tried to use subforms of table 2 linked to table 1 to enter different values of table 2 at the same time.