ok this table members has the following relationships

 

members --< address

members --< phone

members --< email

 

Memberships are individual so there isn't a master "account" or parent record.

 

however there are husband & wife that have either a matching address or phone or even email.

 

With some SQL magic I wonder if there is a way to generate the following "unique" label.

 

 

John Smith

Mary Smith

123 Main Street

City, State, Zip

 

Based on any matching values in either EMAIL or PHONE in an adhoc fashion. 

 

 

Stephen,

 

Are you generating this out of the contact table or the address table? It seems that if you want to combine the contacts for every unique address then you should set up the Execute SQL from the address table. Not quite intuitive, but straightforward.

 

Levi

 

 

-- 

Laura (Levi) Vie | [email protected]  | 573-874-5176 | iChat:  leevie