>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.
Thanks,
TFISHER