I have seen several ways of doing this around here but would like to know what is the correct or preferred way? For simplicity lets say I have the following table structure and these are single parents with children:
TBLParents:
ParentID (PK)
FirstName
LastName
TBLChildren:
ChildID (PK)
ParentID (FK to TBLParents)
FirstName
LastName
I have a main form that allows me to enter/edit information about each parent and on that form I have a subform to enter the child info. I want to be able to search for parents and children which isn't a problem for any parent or for children related to the current parent record. What is the proper way to search for a child associated with a different parent than the current record? By the way this isn't really the subject of my database, I just felt it would be easy for all of us to understand. Thanks
TBLParents:
ParentID (PK)
FirstName
LastName
TBLChildren:
ChildID (PK)
ParentID (FK to TBLParents)
FirstName
LastName
I have a main form that allows me to enter/edit information about each parent and on that form I have a subform to enter the child info. I want to be able to search for parents and children which isn't a problem for any parent or for children related to the current parent record. What is the proper way to search for a child associated with a different parent than the current record? By the way this isn't really the subject of my database, I just felt it would be easy for all of us to understand. Thanks
