Relationship difficulty - what am i doing wrong?
I'm working on a database that helps me for my work (real estate agent).
I already made a different table for the property ( see screenshot 1) and for the contacts (see screenshot 2).
I experienced some difficulties with relating those tables, this mainly because the property table has more contacts (seller /buyer / builder / etc).
So I made different key fields ( see screenshot 3 for detail of relationship).
However if add a new property i cannot use an already made contact? How come?
Also on the contact page (screenshot 2) the reference number of the property is mentioned. This only works for 1 contact..
Can someone please tell me what I'm doing wrong?
If you need more info or screenshots do not hesitate to ask?
Thanks in advance,