webharvest
New member
- Local time
- Today, 07:53
- Joined
- Sep 12, 2006
- Messages
- 6
I set up an Access database to track visiting families. Each person in a family is inserted as a seperate row in my table. The table has the following columns: Head of household, last name, first name, phone, email, address and etc.
I set up a quiery with a pull down menu in my form so when I enter a new entry I can select a head of the houshold to assign each person to. So if we have a family visit that has a husband, wife and a child. There are three entries each having a head of the household as the same. When I use the query to select the head of the household I would like the information that is the same as the "head of the household" (address and phone #) to be automacially filled in from the husband initial entry.
How can I do this?
Thanks
I set up a quiery with a pull down menu in my form so when I enter a new entry I can select a head of the houshold to assign each person to. So if we have a family visit that has a husband, wife and a child. There are three entries each having a head of the household as the same. When I use the query to select the head of the household I would like the information that is the same as the "head of the household" (address and phone #) to be automacially filled in from the husband initial entry.
How can I do this?
Thanks
Last edited: