none
Populating foreign key field with duplicate values RRS feed

  • Question

  • One to many relationship. MS Access form derived from a LEFT JOINed query. Need to allow one primary key value in more than one foreign key field.
    • Edited by MarcusKgosi Monday, March 13, 2017 1:06 PM Title was not specific
    Monday, March 13, 2017 1:01 PM

Answers

  • That is the default behavior in a 1:M join. What issues are you seeing?
    BTW, it is unusual to base one form on a query with 1:M join; that's why we have subforms: the primary table bound to the mainform, and the child table bound to the subform. This is how Access is supposed to work. Don't go against the grain, especially as a rookie.

    -Tom. Microsoft Access MVP

    • Marked as answer by MarcusKgosi Tuesday, March 14, 2017 7:01 AM
    Monday, March 13, 2017 1:42 PM

All replies

  • That is the default behavior in a 1:M join. What issues are you seeing?
    BTW, it is unusual to base one form on a query with 1:M join; that's why we have subforms: the primary table bound to the mainform, and the child table bound to the subform. This is how Access is supposed to work. Don't go against the grain, especially as a rookie.

    -Tom. Microsoft Access MVP

    • Marked as answer by MarcusKgosi Tuesday, March 14, 2017 7:01 AM
    Monday, March 13, 2017 1:42 PM
  • Thanks Tom, the sub-form works.
    Tuesday, March 14, 2017 7:02 AM