Multiple Record Entry

[xraive]

I have two tables

Table1(TripEventTypes)

TripEventyTypeID
EventTypeID

Table2(TripEventTypeDe tails)

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 EventTypeDetail ID = DepartureCity EventTypeDetail Value = City Name

Where EventTypeDetail ID = DepartureDate EventTypeDetail Value = Date

and so on.. for Arrival City, ArrivalDate, Flight Number, SeatNumber

All this would be store in the TripEventTypeDe tails 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.

[FishVal]

Hello.

Looks like this stuff could help you.

Regards,
Fish.

[NeoPa]

In what way is your current solution not working for you? It seems to me that your current solution should be fine.

[xraive]

The Problem NeoPa is that

suppose i would like to enter flight information in Table2

it would show up as

[U]TripEventTypeID  EventTypeDetailID  EventTypeDetailValue[/U] 
       1         DepartureDate           01/03/09
       2         DepartureCity           London
       3         ArrivalDate             01/04/09
       4         ArrivalCity             NYC

The problem might be that this table isn't normalized. I am storing multiple types of data in one column. Also other than in a continous form there doesn't seem a way to edit all 4 records within the same form.

I was thinking of changing the design and adding tables to accomodate "Accomodations, Flights,Taxis,, CarRental" and then relate that to a Trips Table.

What do you think?

[NeoPa]

What is TripEventTypes. EventTypeID? I can't see any explanation for this.

Frankly I'm struggling to get any type of handle on how your data fits together. It's good that you show some example data, but "it would show up as" ... is very unclear as to what you are trying to say. Did you mean "should"? "Does" possibly? Is this talking about how it should show on the form?

I can't make sense of it I'm afraid.

[xraive]

The current setup of tables :

TravelAutohriza tion > Trips > TripEventTypes > TripEventTypeDe tails

Each Travel Authorization has one or more Trips (

Each Trip has one or more Events (i.e. Flight, Accomodation, Taxi, Car Rental)

Each Event has one or more Event Details (i.e, Departure Date, Arrival Date, Confirmation#, Room)

Does this make sense

[NeoPa]

What is TripEventTypes. EventTypeID? I can't see any explanation for this.

Frankly I'm struggling to get any type of handle on how your data fits together. It's good that you show some example data, but "it would show up as" ... is very unclear as to what you are trying to say. Did you mean "should"? "Does" possibly? Is this talking about how it should show on the form?

I can't make sense of it I'm afraid.

Not much I'm afraid. I have a confused picture in my head. I need to know how TripEventTypes. EventTypeID fits into it. This doesn't seem to get me anywhere.