>I have just graduated college and I am writing a vfp30 program that is more intense than what I learned in college I am shure I will do fine but I need a push in the right direction. First I created a form with a grid in it when you add a new record the date is automatically placed in the first field I need the cursor to show up in the next field so the user does not have to click on the feild to enter the information.
>My second Question is I am creating a form that links information from multiple tables I would like to start with a blank form then have the user enter a customer id number and all the rest of the feilds are automatically display the related information. Your help is greatly appreciated. Thank you. WAX
1. For setting the cursor into necessary column in the grid add
something like
thisform.myGrid.column2.setfocus() after your code for adding record.
2. In general, you should set relations for your tables by customer_id. After entering the customer_id you can perform the
SEEK customer_id in Valid event for the customer_id field, and then refresh the form. I prefer to use container object for all controls showing the details. In this case you can refresh all details with
thisform.cntDetails.refresh()Or, use a combobox for customer_id in parent table, that will automatically move record pointer to proper record, and you still need to issue
thisform.refresh(). There are several ways how to get blank fields for the form appearance.
These are just basic suggestions, details depend on your particular task.
HTH,
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison