Link to master

[simoncpage]

I am trying to setup out database for deduplicating. What I want is to be able to link all the duplications to a new master record. Which I have kind of done for example

ID | Master Field

1 | 1

123 | 1

234 | 1

But what I want to be able to do is to be able to search for ID 234 and it returns all records with the same master field.

Any help would be appreciated

[simoncpage]

Answered my own question...normal ID search then an exteneded search with Master fields = 1 .... nice and simple