>>>>I have a form of parent & child (grid). When an user clicks on Add, another form appears as an entry for a new child record. After saving it, the form releases and returns to the primary form. The grid then shows a new record just entered, two rows! In the database only one row was saved. Exited the form then re-opened it, the form still shows two rows. Both rows have same RECNO()#. No matter how often I packed/cleaned up the parent & child files, it still displays the new record as two rows. Strange! Why is this happening?
>>>
>>>Sounds strange, maybe you have a table related to the one in the grid with SET SKIP ON?
>>
>>Thanks for your reply. I've been out for almost a month! Just got back working... ugh.
>>
>>What do you mean, SET SKIP ON? It's not included in the code nor is there a SKIP property. Am I overlooking something?
>
>Hi,
>
>My fault, the command is SET SKIP TO tablename, which is implemented in a data environment by the OneToMany property of a Relation object.
>
>As an example, imagine Customer and Order tables, where there is a one-to-many relationship.
>
>USE Customer IN 0
>USE Order IN 0 ORDER TAG nCustId
>SELECT Customer
>SET RELATION TO nCustId INTO Order
>SET SKIP TO Order
>
>If you were to browse both of the tables simultaneously, and the current customer had 5 orders, you would see the customer record repeated 5 times in the Customer browse.
>
>This feature lets you create the intuitive relationship from Customer to Order (OneToMany) and be able to process the correct Customer for each Order. Otherwise, to be able to always view the correct Customer for an Order, you would need to create a relationship from Order to Customer.

Hi,

I understand what you mean but unfortunately it's not the case. When the cursor pointer is in the grid on the strange duplicate record, both rows are highlighted (only the first row is movable & editable). Both rows are the same record. Interesting thing, when I do PACK & REINDEX, the problem goes away. Whenever I add a new detail record, it happens again.

Thanks!
~d
J