G
Guest
I'm having trouble defining my relationships.
My subjects are:
Household
Client
Appointment
Assistance Provided
Now for each Household there can be only one Client (Head of Household).
In each Household there can be many members, with Client included (they
share types: First and Last Names, DOB).
Within a Household there needs to be an unlimited list of Conditions and
Needs. These are two single lists with combo boxes.
Household must also have an Income table with Type, Amount and Number. This
is an unlimited list with a combo box for Type selection.
I try to create links from my HouseholdID to these 4 seperate lists as
one-to-many but it won't allow it. It allows me to have a one-to-many with a
Client but not with Condition, Need, Income, or PhoneNumbers.
Christian
My subjects are:
Household
Client
Appointment
Assistance Provided
Now for each Household there can be only one Client (Head of Household).
In each Household there can be many members, with Client included (they
share types: First and Last Names, DOB).
Within a Household there needs to be an unlimited list of Conditions and
Needs. These are two single lists with combo boxes.
Household must also have an Income table with Type, Amount and Number. This
is an unlimited list with a combo box for Type selection.
I try to create links from my HouseholdID to these 4 seperate lists as
one-to-many but it won't allow it. It allows me to have a one-to-many with a
Client but not with Condition, Need, Income, or PhoneNumbers.
Christian