>IMO, you should have an integer field for the PK in your VPF tables and use the values from the Paradox table as a Candidate or regular key.

Craig,
I do have a PK Integer field in my table as I am using Views to update my tables.

The problem I have, is that the system I am writing is an "Airline" revenue invoicing system. The user has to select flights from the "other" system, to create an invoice. I need to check prior to displaying these flights for selection, that I don't have them on file already. The candidate key is a flight date, airline code, flight number, suffix and a departure city, so I do a LOCATE on these fields in my table, to see if a record exists.

If the record does not exist, I display it for selection.

Speed is a a big issue, because it is all "Internet" based, so I cannot have a system that drags it's feet ....

If you have any comments, I sure would love to here them.

Cheers,
Mark