recursive parent/child? (a2k3)

Topic

New Reply

I have a table containing information about individuals. I want to be able to associate friends and family with an individual’s record. I know how to do a self-join cboBox, but that’s one person. What I really want is to associate a group of people with that inviduals record. How would you go about it?

E

Reply | Quote

Replies

You should add a new table to you db.
This table would have two fields containing the id from the individual and the id from the person you want to link.
For each person you want to link to an individual, you should add a record to the table.
Use a subform to show this linked persons.

Reply | Quote

You should add a new table to you db.
This table would have two fields containing the id from the individual and the id from the person you want to link.
For each person you want to link to an individual, you should add a record to the table.
Use a subform to show this linked persons.

Reply | Quote