Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2014
    Posts
    2

    Unanswered: Avoid multiple entry for foreign key

    Hi All,

    I have a master to child table relation which is one to many. Each one is represented by a different form.

    The problem is, the user enters the primary key "JobID" on the master form, then he needs to enter a few records on the child list with the same "JobID" which is the foreign key in that case. I don't want the user to enter the "JobID" every time he enters a new record in the child form.

    Is there a way I can copy the primary key to the foreign key each time the user enters a new record in the child form?

    Thanks for your help & time.

    Regards,
    Ali

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Embed the 'child' form inside the 'parent' form.

    make the parent form single display
    Make certain the linked columns are jobid (the wizard should do that for you)
    . Then remove the control containg the jobid on the child form......

    The child form will then only display rows that match the parent forms job id
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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