Relationships

[Nokia8310]

I have a Contact Details Table which has a Primary Key number.
I also have a Property Details Table which has a Primary Key Number.
In my Contact Details Table there can be up to three different people per
contact Id number (this is because they could all be buying the same house)
These people can then be buying a house on their own. Therefore I would have
them down as a different Contact Id ( I could have John, Jim & Jane buy House
A, then John & Jane could buy House B)
I want to create a Form that will have a Tab for the Contact Details and
then a Tab for the Property Details. But I want to only see the Properties in
the Property Details that are relevant to the unique Contact (ie I do a
search in the Form for John and only get to see the Properties that John is
involved in buying)
Is this possible?? I am very new to Access and do not understand some of
the technical jargon that some of use. I am using Access 2003.
If someone could answer me, could they please answer in IDIOTS terms. Many
thanx

 

[Ed Warren]

You have:

Properties
Contacts
Offers
---------------

You need to have the following tables.
Properties -- PropertyID, and other stuff about the property.
Contacts -- ContactID, and other stuff about the contact

Offers (ties Contacts to Properties).
Each contact can have make many offers and
Each property can have many offers (M:M relationship)

OfferID (PK), ContactID(FK --> Contacts, PropertyID (FK -->PROPERTIES) ,
(other stuff about the offer, eg. amount, conditions, date offered, date
expires)

Now you can create a form for Property that has all the property details and
a subform based on the OFFERS table that shows the contacts with offers
pending.
A form for Contacts that shows a subform (based on Offers), that shows the
properties each contact has made offers on.

Hope this helps, if not take a search for how to set up a Many to Many
relationship.

Ed Warren.