Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2002

    Unanswered: ManyTo Many and subform


    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.

    I have attached what I have done so far.

    Im open to critisism!! hehe :-)
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts