Populating foreign key field with duplicate values

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.

Answer 1

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

Answer 2

Thanks Tom, the sub-form works.