Self Updating Table

[etsmarines]

I have a table called contact management.

In it I have contact fname mname lname and suffix.

I also have fields with all of the contacts family information. Brother1FNAME, MNAME, LNAME etc. Brother2FNAME, MNAME, LNAME etc. Parents aunts uncles friends all that.

Is there a way to set it up so that if one contacts parents equals another contacts parents they will automatically fill in the other contacts first middle and last name fiels in the brother or sister fields of their record? So that I do not have to manually do it? Any good family tree scripts or plugins out there as well?

Thanks!

Erik

[bruceR]

You'll need to do a complete redesign.

Almost any time you see FieldName1, FieldName2, etc. it is an indication of a data structure problem where you need real related tables and certainly that is the case here.

I'm sure others will provide more details.