469,072 Members | 1,835 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,072 developers. It's quick & easy.

Multiple Record Entry

30
I have two tables

Table1(TripEventTypes)
Expand|Select|Wrap|Line Numbers
  1. TripEventyTypeID
  2. EventTypeID
Table2(TripEventTypeDetails)
Expand|Select|Wrap|Line Numbers
  1. TripEventTypeID
  2. EventTypeDetailID
  3. 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.
Jun 9 '09 #1
6 1720
FishVal
2,653 Expert 2GB
Hello.

Looks like this stuff could help you.

Regards,
Fish.
Jun 9 '09 #2
NeoPa
32,154 Expert Mod 16PB
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
30
The Problem NeoPa is that

suppose i would like to enter flight information in Table2

it would show up as
Expand|Select|Wrap|Line Numbers
  1. TripEventTypeID  EventTypeDetailID  EventTypeDetailValue 
  2.        1         DepartureDate           01/03/09
  3.        2         DepartureCity           London
  4.        3         ArrivalDate             01/04/09
  5.        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?
Jun 9 '09 #4
NeoPa
32,154 Expert Mod 16PB
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
30
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
32,154 Expert Mod 16PB
@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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by MHenry | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.