Re: [MSAccessProfessionals] Family member tracking.

Art,

So I am thinking out loud here. it would be like one class to many students or one dwelling to many household members. so maybe a table with the dwelling ID as a foreign key in the HH member table

Jim

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Art Lorenzini via groups.io <dbalorenzini=yahoo.com@groups.io>
Sent: Monday, June 1, 2020 11:00 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Family member tracking.

 

That is why I am asking for help. That could very well happen. But it is also understood that people living with the tenant may not be related but they need to be accounted for.

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Valar Dohaeris"

On Monday, June 1, 2020, 12:57:04 PM CDT, Jim Wagner <josephwagner2@outlook.com> wrote:

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