Hi,
I am working with a databse that holds physician info (first name, last name, specialty, facility affialiated with, etc).

Users on the website can search by specialty only, last name only, or search by specialty and facility.

This has not been a problem for me until recently, when our hospital opened an additional facility and many of the docs that are affialiated with the existing facility are, now also, affialiated with the new facility.

The first thing I knew to do was to duplicate those records and change the facility to the new one.

This is not working to good because, if people just choose to search by last name, or specialty only, they will see duplicate records returned on the results page.

I cannot figure out how to solve this.... can somebody please help me?? Thank You!