02/02/2017 at 12:03 pm
#409611
Participant
Steven,
I think the simplest way would be to add a “entry_link” field to the wp_connections table. Since all record types are in the table, ie both family and individual, it would be easy to implement.
Use the entry_link field to store the parent id to connect the child to.
In a family (parent) record, the entry_link value would be the same the id of that record.
In a individual (child) record, the entry_link value would be the value of the id of the parent record if one is associated with it. If not, it would use its own id value.
Then the CVS export would have enough info for a query to separate the records into 2 tables and then have a query to extract what is needed.
What do you think?
Bill