Hi Everyone,

I'm having a problem with a relation between tables in a form.

My form has three tables with relations set between the fields. The grid has columns carrying data from different fields of the different related tables. Sometimes, the child table has no matching link data to the parent table. In such a case, I would like the cell of the child table to be blank on the grid. But...it shows wrong data, linking to the first record of the child table.

Any suggestions will be greatly appreciated!

Thanks,

Steve.