>Terry,
>
>Its extremely unwise to use functions that rely on a specific alias when you join tables in SQL - FoxPro may open the tables you are joining under temporary aliases - therefore the Recno( "customer") may not be the file that is actually used in the SQL. - As Mike says, use a real primary key from the table.
>
>HTH

Hi Ian,

Thanks for your help.