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