>I am new to FoxPro so Please excuse my inexperience. If I have a two tables customer and purchases. How do I record a purchase when adding a new customer with a data entry screen. My previous experience has led me to always use SQL Inserts but I understand this is a slow way of doing things. My second choice was to use a memory variable to take the custid key and use use the Replace command in the purchases table. Maybe I am going about this all wrong, but I just dont know any other way of moving a value in a field in one table to a field in another table with a screen.
>Thanks

SQL Insert is fine. You can do it against both tables consecutively, or combine two INSERT into one transaction.
Also, there are other ways (many:). E.g. you can buffer customer table and use parameterized view against purchase table.