Subsubform -- How do I programmatically show and hide fields?

[painterz]

A Family may consist of 1 or more People
A People(person) is part of 1 or more Family(s) (or only 1 Family??)
A People(Person) lives at 1 and only 1 Address (???)
A Phone is associated to 1 or more People(person)
A Note can relate to 0,1 or many People
A Note can relate to 0,1 or many Family(s)
A Note can relate to 0,1 or many Addresses????

Hi J,

From the top down for the hierarchy based on a neighborhood:

There is a unique address in the neighborhood, the neighborhood is built out so there will not be any new addresses.

There can be more than one family living at the address (but not at other addresses).

There can be more than one person living in the family (but not in other families or addresses). If a child marries, and moves back home--the child is then listed as a primary or spouse and shows as a new family.

The phone number is associated with one person unless it's a home phone then it's associated with the "primary" person (the first person to show in the family, normally the husband), and assumed to apply to the family.

Unless the notes are specific to a person, they are listed on the "primary" person's page, and assumed to apply to the family i.e. move in date for the family. Notes only apply to one family.

Hopefully, I've understood your request and this clarifies my db. The reason I needed to distinguish the families is for the directory. My earlier rendition of my db would only allow me to list one family per address. I also need to have the owners of rentals in the db too. My db would show two families at the same address but the check boxes would distinguish the owner from the renter and the owner hasn't been listed in the directory (they could if they chose to).

Thanks

 

[Cronk]

You might confirm for mine and others benefit, the attached defines the relationships between the tables.

Don't delete families when they move out of the complex. Add a field that the family is 'Inactive' ie no longer there and you might want to have fields when a family first occupied an address and left the address. Similarly, for family members.

In your forms, add to the data source the criteria 'Inactive = False'

This way you maintain a history of previous occupants for any address.

 

[painterz]

Hi Cronk,

Thanks for the graphic. It looks like the relationships I have set in my queries.

There's no reason to keep families when they leave the neighborhood. These are actual houses that are being bought and sold. It's possible someone might move back to the neighborhood, but it hasn't happened yet. We haven't needed a history of who's owned the houses; the county appraisal district would have that info.

Thanks