Im not quite sure if I have established the a many to many relations correct or in fact I need a many to many relationship between the tblclients and tblReferrals_job. What I am trying to is to show what Referral jobs that the Client has been offered. Then when its time for us to make payments I need a subform on the Clients mainform to show all the jobs so that payment details can be entered in a payments table.
Im not sure if a need a relationship between tblCleint and tblpayments. I understand how M to M works but can never figure out how to construction the join.