> I have a parent and child table set up with a one to many relationship. I am displaying a grid which shows fields from both the parent and child record, with the parent record first and then all child records. For those child records which have no corresponding column in the parent, the field appears as a row of asterisks. How can I control this character? It would be really nice if it was blank instead.
>
>
>
http://www.arsindelve.comSee what the NullDisplay property is set to for the objects in the child columns.
Also, you may want to set SPARSE = .F. for those columns.
Normally you should use 2 grids for one-to-many. 1 for the parent table, and 2 to display the child records.
KTB