<div>
adding use tablename to the form's Load event seemed to do the trick. &nbsp;Let me know if this is the wrong way to go
</div>


adding use tablename to the form's Load event seemed to do the trick.  Let me know if this is the wrong way to go

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
This is the first form (.scx)I have created myself to manipulate data, so sorry for my ignorance. &nbsp;I used the wizard to create the form. &nbsp;And it asked for the underlying data so every time I load the form now the data environment shows the table. &nbsp;I want to change the data environment depending on the information in another variable. &nbsp;I know I can delete the file from the data environment and then change the field names to not reference the file. The question is how to load the proper data environment into the form. I have a company variable that changes when the user goes to that company information. &nbsp;So I want to load the relevant data environment (lets call them company1 and company2) for the specific company variable. &nbsp;I should add that I am using VFP 6.0. &nbsp;Thanks for your help.
</div>
</div>


Hi Experts,

This is the first form (.scx)I have created myself to manipulate data, so sorry for my ignorance.  I used the wizard to create the form.  And it asked for the underlying data so every time I load the form now the data environment shows the table.  I want to change the data environment depending on the information in another variable.  I know I can delete the file from the data environment and then change the field names to not reference the file. The question is how to load the proper data environment into the form. I have a company variable that changes when the user goes to that company information.  So I want to load the relevant data environment (lets call them company1 and company2) for the specific company variable.  I should add that I am using VFP 6.0.  Thanks for your help.

Change data environment on fly on Form

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.