<!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">
The associated field in question that I am using has 10 fields. Do you
mean all 10 need to have data for @af to report something other than
"1"? That it will not work if 2 of 10 or 5 of 10 or whatever of 10
fields have data?<br>
<br>
Jeff Harrison wrote:
<blockquote cite="mid20060330155736.32881.qmail@web50701.mail.yahoo.com"
type="cite">
<pre wrap="">--- Jaime Perry <a class="moz-txt-link-rfc2396E" href="mailto:jaime@hoovercs.com"><jaime@hoovercs.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
Jeff Harrison wrote:
</pre>
<blockquote type="cite">
<pre wrap="">@af would not be "1" necessarily, the first time
</pre>
</blockquote>
<pre wrap="">you
</pre>
<blockquote type="cite">
<pre wrap="">encounter the record. The @af value will
</pre>
</blockquote>
<pre wrap="">correspond
</pre>
<blockquote type="cite">
<pre wrap="">to the "row number" within the associated field
grouping. For example if you had A0) as your
associated field group in your map as follows with
</pre>
</blockquote>
<pre wrap="">the
</pre>
<blockquote type="cite">
<pre wrap="">following values for record #1:
Field # Group Value
1 A0) BBB
2 A0) BBB
3 A0) AAA
If you sort the output by A0) then @af will be "3"
</pre>
</blockquote>
<pre wrap="">on
</pre>
<blockquote type="cite">
<pre wrap="">the first record when you are processing the "AAA"
value. This is because it is the third instance
</pre>
</blockquote>
<pre wrap="">of
</pre>
<blockquote type="cite">
<pre wrap="">A0) in the map.
</pre>
</blockquote>
<pre wrap="">Correct, I stated that wrong.
</pre>
<blockquote type="cite">
<pre wrap="">You should certainly not be getting "1" for all of
</pre>
</blockquote>
<pre wrap="">the
</pre>
<blockquote type="cite">
<pre wrap="">values of @af, unless you are only using the first
instance of the "row" in you map.
</pre>
</blockquote>
<pre wrap="">What do you mean by "using the first instance of the
"row" in your map"?
</pre>
</blockquote>
<pre wrap=""><!---->
In my example above that would be if you only had data
in field #1 - not in fields 2 or 3 in the record.
Jeff Harrison
<a class="moz-txt-link-abbreviated" href="mailto:jeffaharrison@yahoo.com">jeffaharrison@yahoo.com</a>
Author of JHExport and JHImport. The easiest and
fastest ways to generate code for filePro exports and imports.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
<a class="moz-txt-link-freetext" href="http://mail.yahoo.com">http://mail.yahoo.com</a>
</pre>
</blockquote>
</body>
</html>