AnsweredAssumed Answered

Relationship difficulty - what am i doing wrong?

Question asked by GillesDebruyne on Dec 16, 2013
Latest reply on Dec 16, 2013 by GillesDebruyne

Title

Relationship difficulty - what am i doing wrong?

Post

     Hi everyone,

     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,

     Gilles

      

      

Screen_Shot_1.png

Outcomes