I have created a DataBase for my Church to track students taking classes.  We are in the testing phase.
I have several tables PersonT, AddressT and so on.  In the person T I hace a PersonID First Middle and Last Names and an AddressID and a PersonType as we're traking Staff, Fathers, Mothers, Children, Admins.  One of the forms is an Family form where we have one FamilyID per Family and I was using a Dlookup to get Father, Mother and childen IDs to show on the form.  It was all working till they threw a wrench into my setup. People might have multiple types uch as a Father might be a staff member too, a Mother might also be a Teacher or an Admin.
So I took the PersonType out of the PersonT and created a PersonTypeT Table and placed it as a subform on the PersonF Form.
My trouble now is that I'm having no luck pulling out the Mother's, Father's or Children IDs
Before when it was in the PersonT I did a Dlookup where FamilyID=[PersonNo] As the FamilyID ends up being the PersonNo of the Head of household. and a PersonType of 13 for Mothers, 14 for Fathers and 15 for Children.
Now I cant figure what to search for in the PersonTypeT Table to get the right ones.