>I've used parameterized views to get subsets of data from one or
>more file based on some value,

Right, that's what I meant: adding a field to your table that indicates
what user is appropriate.

>Secondly, do you mean the Load event of the form and if so how do I add the file programatically?

WITH ThisForm.DataEnvironment
    .CloseTables
    .AddObject('Cursor', 'newTable')
    .newTable.Alias = "SameAlias"
    .newTable.CursorSource = "c:\myPath\" + ALLTRIM(lcEmployee)
ENDwith