<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<br>
Richard Kreiss wrote:
<blockquote cite="mid:006901ca831b$43577080$ca065180$@net" type="cite">
<pre wrap="">
</pre>
<blockquote type="cite">
<pre wrap="">-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:filepro-list-bounces+rkreiss=verizon.net@lists.celestial.com">filepro-list-bounces+rkreiss=verizon.net@lists.celestial.com</a>
</pre>
</blockquote>
<pre wrap=""><!---->[<a class="moz-txt-link-freetext" href="mailto:filepro">mailto:filepro</a>-
</pre>
<blockquote type="cite">
<pre wrap=""><a class="moz-txt-link-abbreviated" href="mailto:list-bounces+rkreiss=verizon.net@lists.celestial.com">list-bounces+rkreiss=verizon.net@lists.celestial.com</a>] On Behalf Of Boaz
Bezborodko
Sent: Tuesday, December 22, 2009 9:47 AM
To: <a class="moz-txt-link-abbreviated" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>
Subject: Question on Header-Detail programming.
I've programmed a few Header-Detail applications where I used a set of
line-numbers for the detail, but each set of line-numbers starts with
1. The uniqueness of each detail is based on the combination of the
header number (say invoice number or order number) and the line number.
I was watching John's Survivor Series where he says to use a unique
number for each detail record.
What is the advantages/disadvantages of using his method versus the way
I've used them in the past?
</pre>
</blockquote>
<pre wrap=""><!---->
I have used your method of numbering each detail line entered. I would say
that the combination of order/invoice + line number is unique.
Numbering the details allows for the them to be displayed in the order in
which they were entered or created. This make matching details to vouchers
or order details easier. I have one application which gives the clerk the
option of displaying in a browse the order details as entered or by item #
or by descriptions.
I have not looked at that in John's survivor series but will take a look at
it.
Richard Kreiss
GCC Consulting
<a class="moz-txt-link-abbreviated" href="mailto:rkreiss@gccconsulting.net">rkreiss@gccconsulting.net</a>
</pre>
</blockquote>
John will probably come on here and point out something that I just
realized as I'm building a new program....<br>
<br>
If you use a master control file then you don't have to count the
number of existing records in order to add one to the end. You simply
go to the control file and pull out a new number and you're sure to
sort in the order in which they were entered.<br>
<br>
Boaz<br>
</body>
</html>