Hi all,

I have a grid in a form, which has a record source comprising of 2 tables, which are related on the data-environment of the form itself. ( I have not used a view here, because, sometimes, if the child table does not have a linking field value, it is created on line by double clicking on the required cell of the grid)

Now my problem is that the grid misbehaves very often showing duplicate values, and wrong values,in the wrong cell even though the relational value between the parent table and the child table is Unique! This is very misleading and seems bizarre...

Any help will be greatly appreciated!

Regards,

Steve