How can a "family of individuals" have a birthdate?
Apologies for the lack of clarity.
I meant "Family MEMBER." It is a related table to the indivudal that allows for family members with minimal biographical information, birthdate being one, to be stored.
Let us say that...
John Smith 10/20/62
From INDIVIDUAL Table
and his daughter
Jane Smith 10/26/99
From FAMILY Table
If today's date is 10/19/2009, I want both Jane Smith and John Smith to pop up in a SINGLE layout reminder me that their birthdays are coming up.
I'd restructure your tables. Put everyone's data, including birthdates in the individual table. I'd only put fields in the family member field that document the relationship between the two individuals.
ID (serial number)
//any other fields specific to the individual
You'd have two relationships:
Individual::ID = FamilyMember::ID
Individual 2::ID = FamilyMember::RelatedToID
This makes Family Member a "join" table linking Individual to itself.
Now, all your birthdate fields are in one table instead of two.