Hello,

I am brand new to VFP, so this question is probably a very easy one. I am using VFP 6.0 with Stonefield and MMF.

I have a large database containing many large tables. One of these tables contains several thousand customer orders, another contains a listing of all the possible products a customer can order, as well as all of the components needed to build each product. For example - Product A contains components 1, 3, 6, and 7; Product B contains componenents 1, 2, and 3.

I need help writing a method that would pull all products containing a particular component and replace that component with a new one for all existing and future orders. For example - Using the data above, if component 2 was to be replaced with component 4, any future orders for product B would contain components 1, 3, and 4.

I apologize if this seems real easy to you, but I am just starting out in VFP and could use any help you VFP Gurus could offer me!

-Justin