>I have a payroll system written in FoxBase (about 10 years ago). I migrated it to FP DOS when I inherited it 5 years ago. We are now rebuilding it in VFP (v6 sp3). There are 4 companies, each with its own personnel file, payroll files, etc. However, the rules are basically the same for all companies.
>
>I would like to use the same forms to edit each company's records. That is have one personnel form, one payroll corrections screen, etc.
>
>In FPDOS or FPWin, we would simply pass a parameter to the screen, and in the setup code select the appropriate table, give it an alias, and process away.
>
>In VFP, from what I have seen, the form's controls are instantiated before the INIT for the form, so a parameter can't be used to select the appropriate table...the table needs to be open at the time the controls are instantiated since they are bound.
>
>I guess I'm just searching for a clue or an idea. This seems to be a problem that is much more complicated in VFP than it was in FPWin.
>
>Thanks in advance.

You're right, the order of instanciation of controls in VFP disallows changing table aliases in the init. What you can do, however, is change them from the form.load depending on the value of an app object property or a global variable. Just check for the existence of the object or variable and if it has been defined, loop through the cursors in the DE, and change the CursorSource property of the cursor object.