I have three tables:
Contacts; id, Client_SSN, client_name
Family; id, Family_SSN, family_name
Accounts. SSN, AcctNumber
I would like to create a query that will search for all accounts associated with a household (i.e. the accounts with SSN equal to Client_SSN and Family_SSN), but the results must be editable as it will be the basis of a subform.
A union query got me the results I wanted, but wasn't editable. Same when I used an OR statement (I think the issue is that there are three tables?).
Perhaps if I could create a query that gets Client_SSN and Family_SSN in one field, then do my select query based on that? I'm a complete novice and completely lost.
Next, I will need to incorporate a Business table that has Tax_ID field as well to include those accounts. But first things first.
Any help is greatly appreciated!