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?
 Chicago
 Illinois - United States
 Ken Blum
 To: Mike Lane
  Where is Mike Lane?
 Barrie
 Canada
 Mike Lane
 Tags
Subject: NullDisplay & Sparse
Thread ID: 22691 Message ID: 22751 # Views: 22 # 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.

KTB

COMPLETE THREAD

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