Is part of this message missing???
>>>I am trying to split a table (imported from FP
>>>2.1). Each record describes a 'grant' and the
>>>customer data associated with that grant. As
>I'm
>>>sure you're aware, there are multiple records
>>>containing the same customer data. I'm trying
>to
>>>seperate the customer data from the 'grant'
>data.
>>>
>>>My problem is that when I try to create a
>primary
>>>key I get 'uniqueness' errors. I can insert a
>>>field into each record generating a unique
>number
>>>( 1+(1000000*RAND(RECNO())) ) in order to get
>>some
>>>kind of primary key, but this still doesn't deal
>>>with duplicate customer info.
>>>
>>>Can anyone tell me how to programatically
>>>eliminate duplicate data while retai