>>Hi
>>
>>I have a list of individuals with a key of individual_ref
>>those individuals can be linked to a partner by family_ref
>>
>>so I would have a row
>>
>>individual_ref family ref
>>58056 174279
>>174279 58056
>>
>>I am selecting a random number of individual but I don't want partners to be selected
>>
>>How can I do that.
>>
>>Thanks
>>
>>Nick
>
>
>UPDATE:
>I just saw that your data has cross reference. How do you know what is partner and what is family?
>From the data you provided which record you want?

It doesn't matter

I am randomly selecting and I don't want the random selection to pull out someone and their partner.

hanks