Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Unanswered: Multiple Record Entry

    I have two tables

    Table1(TripEventTypes)
    TripEventyTypeID
    EventTypeID

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


    Is there an alternative?

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    What is the PRIMARY KEY in your tables, (Don't put the different data in one field, learn something about DATABASE NORMALIZATION, DOMAIN).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •