Steve,

The answer should lie in your general scheme for keeping the companies straight. At what point is the user choosing a company, and how are you keeping track of that?

Do the tables have different names for different companies, or are they in different subdirs? If different subdirs you just set the path. If you use the old SBT system of FileNamexx, where xx is the company number, then do you have a public variable naming xx? These questions are just meant to give you some idea of how the problem has been solved by others in the past.

>The problem is, the form won't know what table to open until the INIT fires. If I open them in the LOAD ... that's the real dilemma.
>
>>Steven,
>>
>>There are a couple of ways to do this. I'm partial to opening the tables in the LOAD method, and always using the same alias. This way the controls will bind just fine.
>>
>>For questions like this, remember LISA G, the order of events when running a form:
>>1. Load
>>2. Init
>>3. Show
>>4. Activate
>>5. Got Focus
>>
>>Hope this helps
>>
>>>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.