You should open all tables shared in your form's DE or in Load method (if you want to do it in code). Never write select 1, select 2, etc., always use SELECT 0.

Your main form should have private datasession. If you invoke child forms from your main form, they should use default DS, this way they would share same DE as the "main" form. If all forms are indepemdant, all of them should use private DS.

>hi all,
>
>i useto free tables at my project,
>i put all tables i use at the mean form as (at procedure activate)
>i need to use those tables at (add form1,modify form2,delet form3.......)
>i get sometimes errors(alias not found, file must open exclu) when i move from form to another....
>/remark:-more one user can useit
>

>under//object myform      procedure    activate//
>select 1
>use mstr
>select 2
>use trans1
>select 3
>use book1
>
>select 4
>use book2
>select 5
>use temp
>*zap
>delete all
>

>
>thanks.
>
>m.qasem