S
Serendipity
I am really, really confused because this is all new to me.
I have a people table (tblPeopleInfo) where I have a field for last name,
middle name, first name, home phone, cell phone, etc., for all phone
possibilities. And then I did the two other fields that Karl told me about: I
called the first one "Family Tie" (this should have info telling what master
family they are in, I think) and the second one "RelationshipType" (the one
that is father, grandfather, etc.) I made the Relationship Type a lookup so
that I could put my values in a table for consistency. I also have another
lookup field: OtherAddressType. And in the relationship window I have the two
copies of the tblPeopleInfo, I drug the fldPeopleInfoId field to the
"fldRelationshipType" field (of the copy of the table). Did I misunderstand?
Should I have drug it to the "Family Tie" field.
How does the form and subform field work? What fields are in the form and
which ones are in the subform. I tried several things but couldn't make it
work.
Thanks!
Marie
I have a people table (tblPeopleInfo) where I have a field for last name,
middle name, first name, home phone, cell phone, etc., for all phone
possibilities. And then I did the two other fields that Karl told me about: I
called the first one "Family Tie" (this should have info telling what master
family they are in, I think) and the second one "RelationshipType" (the one
that is father, grandfather, etc.) I made the Relationship Type a lookup so
that I could put my values in a table for consistency. I also have another
lookup field: OtherAddressType. And in the relationship window I have the two
copies of the tblPeopleInfo, I drug the fldPeopleInfoId field to the
"fldRelationshipType" field (of the copy of the table). Did I misunderstand?
Should I have drug it to the "Family Tie" field.
How does the form and subform field work? What fields are in the form and
which ones are in the subform. I tried several things but couldn't make it
work.
Thanks!
Marie