Multiple Record Entry

[xraive]

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.

 

[rommelgenlight]

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

 

[xraive]

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.