By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,536 Members | 2,165 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,536 IT Pros & Developers. It's quick & easy.

Multiple Record Entry

P: 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
Share this Question
Share on Google+
6 Replies


FishVal
Expert 2.5K+
P: 2,653
Hello.

Looks like this stuff could help you.

Regards,
Fish.
Jun 9 '09 #2

NeoPa
Expert Mod 15k+
P: 31,494
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

P: 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
Expert Mod 15k+
P: 31,494
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

P: 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
Expert Mod 15k+
P: 31,494
@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.