Hi Gary, I am afraid not to understand your real problem.
If you want to have a 'unique' (discriminant ?) index , you can build a primary key. But if you already have a primary key (on trans_id for example), a candidate index will be ok. You must be aware of one thing (that annoy me A LOT) : you can't have more than one blank line in your table with a candidate index or primary key.
CAUTION : in VFP a 'UNIQUE' index means that it will keep only the first occurence of a value and it is not very useful ...
HTH The Foxil _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/51783694.7020...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.