Hi Zaraq,

You are trying to do administration of data as well as maintenence all at the same time.

Let the form do the administration of the data. Things like adding records and deleting records with grids. Create seperate form from where users can do Pack, ReIndex etc.

For your form's grids simply put Table1 and Table2 in the DataEnvironment of the form, set the DataSession to Private and set the Table's BufferMode to Optimistic Table.

Now you do not need to worry about selecting the right alias etc. Use APPEND BLANK and DELETE commands to add or delete records. Use TABLEUPDATE() to Save and TABLEREVERT() to Discard.

Moreover, this way multiple users can access the same data and the same forms can be opened multiple times by a user. Commands like PACK take longer to execute and require exclusive use of tables.


>I have made a form with a pageframe with two grids on it.TableA is on grid1 with record source type as alias and record source as TableA and Table B is on grid2 with record source type as alias and record source as TableB.If I try to save records in Table1in grid1 and then try to put some records in the other table Table2in grid2 no record is saved in Table2 .I know I am not selecting the tables properly in the SELECT Statement.Please Help.
>Also if I try to set delete on and then issue a Pack command , a dialog box appears with the message FILE IS IN USE.So I cannot PACK the tables via forms.I have to close the form and then issue a CLEAR ALL command and then I can DELETE and PACK the table.I am using a SELECT TableA and =TABLEUPDATE (.T. , .T. , TableA) statement in the ADD button.Should I use USE instead.
>Sorry to be a bother.Thanks All
>Zaraq Bari MAlik