WebSmart Code Samples
 

Detail File Record Count Example

Description: This program displays a header file which can drill down to a details file display. In the Header subfile there is a column that lists the record count for the detail file which correspond to each header record. The record count is displayed in red.


Click here to view step by step instructions on how this program was created


Order Number: 
   
Action Order Number Purchase Order / Description Customer Number Order Date Order Total Number of Detail Records
display Details
 100026 PO Ref# 3924893 0000001 06/16/2007 54,801.74 13
display Details
 100027 Special guitars 0000002 09/24/2006 166.94 6
display Details
 100028 Post holiday replenishment 0000003 01/28/2006 321.00 5
display Details
 100029 Custom order 0000006 05/14/2006 42,258.87 6
display Details
 100030 Standard Order PO Ref# 39245 0000005 06/10/2006 81.40 1
display Details
 100031 Special Order: for M. Bossy 0000004 03/08/2006 55,969.70 3
display Details
 100032 PO Ref# 4634343 0000001 07/21/2007 51,595.00 5
display Details
 100033 PO Ref# 46346 0000002 05/27/2006 1,237.97 3
display Details
 100034 PO Ref# 2342893 0000005 02/23/2006 55,940.00 3
display Details
 100035 Custom Orders PO Ref# 2342353 0000004 02/27/2006 1,900.00 1
display Details
 100036 Special Order: Albert Knudsen 0000005 08/07/2006 169.07 4
display Details
 100037 Jen's new guitar 0000007 04/28/2006 47,850.85 4
display Details
 100038 PO Ref# 2346 0000004 11/02/2007 3,150.60 1
display Details
 100041 acoustic guitars 0000004 10/04/2006 1,784.22 4
display Details
 100042 Acoustic guitar order 0000009 11/15/2007 65,639.19 6
display Details
 100046 Replacement guitars for P. Townshend 0000004 04/12/2007 2,469.38 2
display Details
 100048 Christmas season order 0000004 11/15/2007 3,554.56 4
display Details
 100049 PO #783410 0000004 10/13/2007 58,081.56 4
display Details
 100056 Jen's new guitar 0000007 12/08/2007 1,469.37 3
display Details
 100062 Replacement guitars for P. Townshend 0000008 12/18/2007 11.40 1

next  Next Page
  This example was created using WebSmart.

www.excelsystems.com