Relationships

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
 
G

Guest

In speaking of relationships you gave us your "subjects." What you need to
post is the table structure with datatype and primary key fields identified.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top