Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Blum
  Where is Ken Blum?
 Illinois - United States
 Ken Blum
 To: Mike Lane
  Where is Mike Lane?
 Mike Lane
Subject: NullDisplay & Sparse
Thread ID: 22691 Message ID: 22751 # Views: 2 # Ratings: 0
Version: Visual FoxPro 7 Category: Grids
Date: Thursday, April 24, 2003 5:57:10 PM         

> 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.com

See 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.



One to many in grid shows ******* Posted by Mike Lane @ 4/23/2003 9:45:16 PM
RE: One to many in grid shows ******* Posted by Luis Navas @ 4/24/2003 12:32:22 AM
NullDisplay & Sparse Posted by Ken Blum @ 4/24/2003 5:57:10 PM