See
Re: Losing grid formatting Thread #
1099587 Message #
1101508>I have a form that uses a single table in a parent child relationship. The child records are displayed in a grid. My user wants to be able to delete all the records in the table and append in a new set of records from outside sources. When the table is acting as the parent, there is a unique index set so that each combination of 3 fields (_street,_from, and _to) appears only once.
>In order to zap the existing records, I need to release on of the instances of the table. This breaks the relationship and destroys the setup for the grid. I can manage almost the whole thing with the following code except that when the new records are appended into the table, the grid displays only a single child record (multiple times). Also, I can't figure out how to return the checkbox in column3 as the current control.
>Any thoughts would be welcome.
>
<snip>
--sb--