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