Ocean West Posted March 29, 2013 Share Posted March 29, 2013 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. Link to comment Share on other sites More sharing options...
LVie Posted March 29, 2013 Share Posted March 29, 2013 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4066 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now