[AccessDevelopers] Relationships and table design problem

 

I am working on a new database from my travel agency. Here are the tables I am concerned about.
Client table
Trip table
Reservation table
Passenger table

A client can have 1 or more passenger related to them. the client is paying for the trip.

A client can have multiple trips.

Each trip can have multiple reservations e.g. Hotel, Air, and Cruise.

So a 1 to many for Client to Trip
A 1 to many for a trip to one or more reservations

So the trip table has the following:
TripID
ClientID
Passenger1ID to Passenger8ID (allowing for a max of eight passengers on a trip)
TripName
StartDate
EndDate
etc.

So what is the proper way to relate a single trip to multiple passengers? Apparently I need some kind of connecting table for a many to many???? Just not sure how to handle this.

I can post the relationship print out if that would help or the proposed table documentations as generated by Access.

Also using Access 2010 if that makes any different.

Thanks

Jay Beckham

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2

Visit Your Group

Please zip all files prior to uploading to Files section.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___