Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    UK
    Posts
    78

    Unanswered: Linking tables-compound keys?

    Is it possible to nominate five fields and usthem combined to make a unique key?

    ___________________
    FlightNo |
    OccurrenceNo |
    SectorNumber | ______ = Unique
    From |
    To |
    ___________________

    I am trying to write a booking database but I am having trouble linking the passengers to the flights!
    I can't just use an ID to link the flight to the customer as the data in the flight schedules can change.

    Im tired and stuck on this one!

    Any ideas?
    the light is on, someone is home, but they dont know they are. HELLO!

  2. #2
    Join Date
    Sep 2003
    Location
    UK
    Posts
    13
    Yes - in Table Design select the five columns and then right click to bring up the shortcut menu. Make these the primary key.

    You can then link all five into each query. (Efffectively these are an entity).

    Regards,
    Sioma

Posting Permissions

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