Access Entering data on form for query that joins two tables
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
![1]()
![2]()
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
A form should only be tied to a single table. So you should have a Household form and then use a People Subform within it. Then you'll be able to add ass many people to each household.
Agree, with Daniel. If you need more than one of something that relates to something on your main form, then you need a subform.
This could apply to phone numbers or email addresses on frmPeople, members on frmHousehold, or OrderDetails on frmOrders.
When you create this subform, you create a link between the main form and the subform by clicking on the subform control, opening the Data tab on the Properties dialog, and setting he appropriate values in the linkMaster and linkChild properties.
HTH
Dale
This could apply to phone numbers or email addresses on frmPeople, members on frmHousehold, or OrderDetails on frmOrders.
When you create this subform, you create a link between the main form and the subform by clicking on the subform control, opening the Data tab on the Properties dialog, and setting he appropriate values in the linkMaster and linkChild properties.
HTH
Dale
Premium Content
You need an Expert Office subscription to comment.Start Free Trial