Hi Jim,
The easiest way to update a table in the calling form is to set the modal form's datasession to DEFAULT not PRIVATE. It actually defaults to the DS of the calling form. However, if you do this be VERY careful about putting any tables into the modal form's DataEnvironment. Open your child table in the Calling form, and open/close any other tables programmatically.

There is no way to PACK without exclusive use of the table. If you are adding/deleting records constantly try re-using the deleted records instead of simply using Insert or Append Blank.

HTH
Barbara

>I have a form (modeless) that calls another form (modal), and in the second form the user updates a table (child table to the main table of the base form) with SQL Deletes and Inserts. Both forms use a private datasession.
>
>The captions of both forms contain a calculation on the records in the child table and requires that the table's content reflect the changes just made in the child table. But calculation method returns a value reflecting the content of the table prior to my deletes and intserts.
>
>This is probably a very basic question, but is there a command I can use to update the child table?
>
>ALSO: after the deletes, I want to pack the child table. Is there a way I can do this w/o USE'ing the child table. IOW is there a SQL method of packing the table that doesn't require me to get an EXCLUSIVE lock on the table (something I can't afford to do in the shared environment.)
>
>TIA
>
>Jim