>>I have a form that is used for each users timesheet entries.
>>The problem that I have though is that each user has their
>>own DBF. (i.e. \DATA\THSHT\%user name%\TMSHT.DBF). Each user
>>can only access their own TMSHT.DBF.
>
>I know it isn't answering the question you asked, but how about
>using a parametrized view? Is it a question of file-level
>security?
>
>As far as your question goes, you could add the correct file to
>the DataEnvironment in the Load event. Check the properties sheet
>for the properties you want to set....
I've used parameterized views to get subsets of data from one or more file based on some value, but how would I set up one to be based on a particular table depending on the user name.
Secondly, do you mean the Load event of the form and if so how do I add the file programatically?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.