Re: [MSAccessProfessionals] Family member tracking.

Art,

 

What would happen if you had 2 HH members? Both on the lease or rental agreement and they are not related?

 

Jim Wagner

 

Sent from Mail for Windows 10

 

From: Art Lorenzini via groups.io
Sent: Monday, June 1, 2020 10:49 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Family member tracking.

 

I need to set up a couple of table in which I track a primary tenant information but also need to track their household members. I thought of a main tblTenant for the Primary tenant (tenant Head of Household) and a table tblHHMembers to track the household members but that seems to me that would be redundant information because we need to track SSN, Relationship, DOB, etc for each member just like we do for the Primary Tenant. Have you seen any example of this or have any ideas?

Thank you,

Art Lorenzini
Sioux Falls, SD