missing records in form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

morel-lover - 31 Mar 2008 01:31 GMT

I am designing a database for personal use. I have 4 tables: tbl-primary with
ID as primary key; tbl-spouse with ID as primary key; tbl-children with ID
and First Name as primary key; tbl-relationship with relationship as primary
key.

Relationships: 1to1 tbl-primary to tbl-spouse; 1to many tbl-primary to
tbl-children

In the form that I created for data entry it will not show records from the
primary table that do not have a related record in the spouse ID field.

There are no filters or queries involved. If I enter a number in the spouse
table for ID, the record will show. I hate to have a bunch of records that
only have and ID number in the spouse table for those in the primary table
who do not have a spouse.

Can anyone help???
Thanks!!!

Reply to this Message

John W. Vinson - 31 Mar 2008 02:12 GMT

>I am designing a database for personal use. I have 4 tables: tbl-primary with
>ID as primary key; tbl-spouse with ID as primary key; tbl-children with ID
[quoted text clipped - 14 lines]
>Can anyone help???
>Thanks!!!

A better design would have ONE *People* table. Husbands, wives and children
are all instances of people!

With your current design, though, you should consider using a Form for the
primary person, with a Subform for the spouse table, using the ID as the
master/child link field; and a separate Subform for the children, same link.

How you'll handle 21st century blended familiies where the parents have both
been divorced once or twice and have children from two or three partners I
don't know...

Signature

John W. Vinson [MVP]

Reply to this Message