>I have two table with a one to many relationship. The many side of the table I am putting into a grid. When running the form the grid is displaying all 354 records in the table. The 354 occurences are all the same. I am able to select a new record from the one sided table. The grid will update the new ID with that data, but again it will display all 354 records with the same information. I am using the data environment, that has the relationship of these tables setup.
>
>Anyone have any ideas on what could be wrong???
>
>
>HOlly Clawson
Holly, check the data information on the grid to be sure you have ChildOrder, LinkMaster and RelationalExpr set correctly. Then double check all your methods to be sure you haven't changed the index. The grid WON'T re-set the index if it's been changed elsewhere, and your link will be broken.
I've had the same trouble - usually it appears after I've added something else, like a lookup, and my indexes got re-set.
HTH
Barbara