>well i tried...
>
>use TableA in 0 alias Main
>
>use TableB in 0 alias Child
>
>set order to tag FkField in Child
>
>select Main
>set relation to PkField into Child
>go top
>
>
>which gives me the file in use error

Which particular line gave you the error? Did you remove the tables from DE and tried the code above (or similar) in the Form's Load method?


well i had on int
Select TableA

but i removed that and added

>use TableA in 0 alias Main
>
>use TableB in 0 alias Child
>
>set order to tag FkField in Child
>
>select Main
>set relation to PkField into Child
>go top

both use give the error