467,212 Members | 1,186 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Multiple Record Entry

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
  • viewed: 1689
Share:
6 Replies
FishVal
Expert 2GB
Hello.

Looks like this stuff could help you.

Regards,
Fish.
Jun 9 '09 #2
NeoPa
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
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
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
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
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
13 posts views Thread by ricky.agrawal@gmail.com | last post: by
4 posts views Thread by ApexData@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.