hello there,

i'm a realtor and i'd like to have a resume of all the property visited by a and for all the clients that went to visit a property.

I'd like these relationship to be connected. So if Mr Brown visits the apartment A automatically on the report of the apartment A i can see that mr Brown went to visit  that apartment

And the same if I add an appointment on the Apartment form i would like to see on clients side that he went to visit that apartment on a certain date.

I'm not sure how many lookups field i should use.

Can u help me pls?

thanks