A simple relationship question from a newb

qurn

Registered User.
Local time
Today, 13:55
Joined
May 2, 2005
Messages
63
Ok, I have studied up on relationships, and read a lot of these threads but, I still have yet to find help. It seems a lot of the people on here have difficult problems that require dificult answers. Basicaly I have two tables Tblresort and Tbllifts, now there can be many chair lifts for each ski resort, so this would call for a many-to-one relation ship. Now, I create a relationship for the fields, and enforce refrencial integrity and all that. Now what do I put into the related field in Tblresort to get the lifts with ID#'s 1-8 to be related to the first resort.

I hope this all makes sense, so far I can only get one lift conected to the resort.

Thanks in advance
 
The relationship goes the other way. One lift can belong to only one resort so the ResortID goes in the lift table rather than the liftID going in the Resort table. Resort is the 1-side of the relationship and lift is the many-side. The ID of the 1-side table is placed in each related row of the many-side table to make the relationship.
 

Users who are viewing this thread

Back
Top Bottom