I am trying to get a database going for a small family-based Christian school. The problem I am running into is this: Everytime I create a student record, I want a record of the family automatically created by last name if one doesn't exist. I've tried making a relationship between the "Last Name" of the Student table and the "Family Name" of the Family table and for the ability of that relationship to create records in the Family able. What else do I need to do?

Thanks

Chris

Hi Chris,

In my opinion, the best approach is to find for the family first, create the family record if one doesn't exist, and then create the related student.

A database should not assume that the last name of the student is necessarily the last name of the family, and it should not use names as primary relational keys.