What do you think is best to use in a VFP project when it comes to character indexes or integer indexes? If you use a integer it is very easy to just generate next key. But some times you need a compound index as in browsing items on an invoice. Then I will need a index like Str(invoice_id)+Str(item_id), which is not so easy and fast? to use. What is your opinion on using integer indexes or character indexes as primary key?