>The problem seems to occur when there's two or more child records for any given parent record. The parent table contains a record for each of the child records in the child for that parent. the duplicate records have ****** in every field. If I set stat on and scroll through the database the record number remains the same fot each of the the parent records & their suplicates.
>
>If I open the parent table on its own without the one to many relationship the strange records disapear.
>
>Hope this explains it better ? LOL
Robin,
Turn off one-to-many. Stars stand for 'ditto'. You don't need it there do you ? Show parent fields on form (separate from grid) or use 2 grids one for parent and one for child.
Further I don't think you'd ever want to do editing in such a grid. Why not simply use an SQL rowsource (or view) instead.
You might even want to use an HierarchicalFlexGrid activex instead (search on it for samples).
Cetin