Forms and dataenviroment errors

[Mrall]

I have two forms with 3 to 4 tables in each of them. The tables in each curser are in differant orders. ie. form2
has select 1 as a table called import.dbf in form1 select 1 is a table called master.dbf

For some reason when I release form2 to go to form1 select 1 is import.dbf instead of master.dbf

Im sure there is something simple that I need to do after releasing form 2.

thanks for any help

 

[TamarGranor]

First of all, if you're choosing particular work areas for tables, don't do that. You should never care which work area a table is in.

To solve your immediate problem, make sure you've set the DataSession property for the forms to Private.

Tamar

 

[JRB-Bldr]

To elaborate on Tamar's suggestion "if you're choosing particular work areas for tables, don't do that."...

SELECT the tables by their Alias name instead of their work areas. That makes things MUCH easier to understand.

So instead of using
SELECT 1
do
SELECT import
or
SELECT master
whichever is desired.

Good Luck,
JRB-Bldr

 

[Mrall]

Thanks Guys! That solved the problem.

You are correct that I should use the alias instead of the workarea.

I was not aware of the pubic or private seting for the dataenviroment.