October 30, 201015 yr Newbies I'm not sure if this is the right area for this question. I'm setting up a db that has the usual first name - last name but also has partner first name - partner last name. How do I set an ID to relate to a table that contains other family last names that are not the same? i.e. if last name is Smith and the partner last name is Jones how do I set the relationship ID? The second table holds a list of family members and other private details. Thanks for any help.
October 30, 201015 yr Welcome to the forums This can be accomplished by having a join table between the person and his/her relations - joined by the unique record IDs.
Create an account or sign in to comment