Multiple Record Entry

xraive

I have two tables

Table1(TripEventTypes)
Table2(TripEventTypeDetails)
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.

Jun 9 '09 #1

FishVal

Hello.

Looks like this stuff could help you.

Regards,
Fish.

Jun 9 '09 #2

NeoPa

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

Jun 9 '09 #3

xraive

The Problem NeoPa is that

suppose i would like to enter flight information in Table2

it would show up as
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?

Jun 9 '09 #4

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.

Jun 9 '09 #5

xraive

The current setup of tables :

TravelAutohrization > Trips > TripEventTypes > TripEventTypeDetails

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

Jun 9 '09 #6

NeoPa

@NeoPa
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.

Jun 9 '09 #7