6 Replies Latest reply on Dec 16, 2013 9:43 AM by GillesDebruyne

    Relationship difficulty - what am i doing wrong?



      Relationship difficulty - what am i doing wrong?


           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,