I recently purchased the book Special Edition Using VFP6 and there is a topic about using Bound vs unbound data. Similar to VB where you can use a data control to bind the data to a table I understand I can bind a text box on a form to do the same thing, As a textbox is is tyoed in the data in the correpsonding field is updated or added. But what if you need to do some conditonal processing before adding the new record? Can you use SQL to add the record? Wont I have more control of the data If I dont have the textbox tied directly to a field? I know the preferred way is to use the control source but I would like to to try adding it a different way.


Basic Data Entry screen

Last Name
First Name
Address

once info is entered how do I add it to a single table or multiple table in a multi-user environment?