B
BillE
In my database I have a People table and an Address table. The relationship
is many-to-many - multiple people (in the same family) can have the same
address, and one person can have multiple addresses (home, work, etc.), so I
have a interim table linking PeopleID and AddressID (with a boolean
CurrentAddress flag).
I also have a table linking People to People, so family relationships can
be managed.
The database design is easy enough, but the form I created to manage all
this became a little clumsy to use. It works OK, but I wondered if anyone
has any nifty ideas I didn't think of.
When I display detailed information for a person, other people with the same
address are listed. Detailed information can be displayed for these other
people by selecting them. If a child grows up and moves out, it is
necessary to have a New Address button on the detail form, which then
creates a new record in the Address table, and links the child to this new
record as the current address. The list of 'Other people at the same
address' then needs to be cleared. I need a separate list to display family
members, since they may not be at the same address.
If the family moves to a new location, I have to provide a means for the
user to indicate that everybody at this address should be changed to the new
address.
Like I said, it works, but I think it could be neater and if there are any
examples of more user-friendly solutions for managing family relationships
and addresses I would much appreciate it.
Thanks
Bill
is many-to-many - multiple people (in the same family) can have the same
address, and one person can have multiple addresses (home, work, etc.), so I
have a interim table linking PeopleID and AddressID (with a boolean
CurrentAddress flag).
I also have a table linking People to People, so family relationships can
be managed.
The database design is easy enough, but the form I created to manage all
this became a little clumsy to use. It works OK, but I wondered if anyone
has any nifty ideas I didn't think of.
When I display detailed information for a person, other people with the same
address are listed. Detailed information can be displayed for these other
people by selecting them. If a child grows up and moves out, it is
necessary to have a New Address button on the detail form, which then
creates a new record in the Address table, and links the child to this new
record as the current address. The list of 'Other people at the same
address' then needs to be cleared. I need a separate list to display family
members, since they may not be at the same address.
If the family moves to a new location, I have to provide a means for the
user to indicate that everybody at this address should be changed to the new
address.
Like I said, it works, but I think it could be neater and if there are any
examples of more user-friendly solutions for managing family relationships
and addresses I would much appreciate it.
Thanks
Bill