>I'm experimenting with some COM stuff. I want to build a VB customer form with about 10 textboxes on the form. The Save button on the form would loop through the textboxes and pass the values in them to the VFP COM object. And the COM object vaildates the data and saves it to the customer table. My problem is what is the best way (generically) to map each textbox to the correct fields in the customer table?
>
>smith

Hi Chris,

You don't need to really "map" textboxes to fields. There are different ways to do this. The best way to interact with COM is to call its method. For example, you may have a method in COM object which accepts a field name(s) and value(s) as the parameters and let that method to do validation and REPLACE for your fields. Or, (depending how you do the validation) you can form a VFP SQL UPDATE statement as text string and pass it to VFP COM module to execute.