Hi
I have an Access query which is the combination of two tables shown in the image. There are multiple entries for the tblPeople for each entry in tblHouseholds. I want to set up a single form with all fields where the user can make these entries. I have a query that combines both tables.If I let Access create a form from this query automatically I get the form shown in the second image - the problem with this form is that it looks like I can enter one person per household when I want to enter multiple