I am trying to create a membership database for a church. I need to have all members entered into the database, then for the members I need to have their spouse name and anniversary, and the names of their children. I am trying to get a subform for each of these into the main form, but when I try to use it it just shows the spouse in the first spot as the spouse for every record. I need to lock or bind this information to each "Master" form. So that joe smith at 123 anyplace somewhere usa will show his spouse and children while joe smith at 456 somewhere anyplace usa will show his spouse and children also the spouse's page (jane smith) will show joe smith as her spouse with their children. I would also like to hyperlink the spouse name so that if you click it their record will be pulled up. Anyone that can help me with this endeavor would be greatly appreaciated.