A
Amanda
I'd like to create a form so that users can quickly merge duplicate records.
We are a non-profit, and tend to serve families, so I have one table for
"Households" (unique addresses) and one for individuals- tied to the
Household by an ID field, and a journal table that tracks an individual's
interactions (visits, event attendance, etc.)- tied to the individual table
by an ID field.
The merge form needs to have two columns. The user can select the individual
based on a search for each column, and then choose some merge options from
buttons between those columns. (copy the record's address on the right to the
record on the left, delete the record on the right, append the individual's
journal records from the right to the left, etc.)
Right now, I'm just trying to figure out how to create the two columns. I
created a subform with its own search that could be used for both columns
(the subform appears on the main form twice), but cannot get the subform's
"search" to function on the main form.
Could someone get me going in the right direction to pull this off?
We are a non-profit, and tend to serve families, so I have one table for
"Households" (unique addresses) and one for individuals- tied to the
Household by an ID field, and a journal table that tracks an individual's
interactions (visits, event attendance, etc.)- tied to the individual table
by an ID field.
The merge form needs to have two columns. The user can select the individual
based on a search for each column, and then choose some merge options from
buttons between those columns. (copy the record's address on the right to the
record on the left, delete the record on the right, append the individual's
journal records from the right to the left, etc.)
Right now, I'm just trying to figure out how to create the two columns. I
created a subform with its own search that could be used for both columns
(the subform appears on the main form twice), but cannot get the subform's
"search" to function on the main form.
Could someone get me going in the right direction to pull this off?