Need help (again) understanding something...

[Jim Creak]

Yes, for each record created in Omnis Classic there is a unique and sequential Sequence field set. You can add these to your file if you create a field and make it Field Type Sequence  you will find that you can modify this field, but you can reference it and find on it if required.

When a file in connected to another file there is link made between the child with the sequence field on the parent.
 
Thanks
Jim

JACSoft Programming Ltd. <http://www.jacsoft.co.nz/main.shtml>
> On 31/01/2017, at 7:15 am, Mark L. Wise <mark at alpha2.com> wrote:
> 
> Ok.  The TRANSAC file is linked to a CLIENT file and the ACCOUNT_NO field is in the client file.  One record in the TRANSAC file matches on the find, but the other doesn't.
> 
> There is no field name in the TRANSAC file that could link to the CLIENT file.  Is there a "hidden" link between a record and linked files that I can't see/modify?
> 
> Mark
> 
> 
> On 1/30/2017 12:57 PM, BILL tube wrote:
>> When a file is connected it will automatically read the connected record anytime a record is read.  You can look at “modify file class” there is a pulldown menu “modify” and one of the options is connected files.
>> 
>> 
>>> On Jan 30, 2017, at 9:47 AM, Mark L. Wise <mark at alpha2.com> wrote:
>>> 
>>> Explain "connected file"?
>>> 
>>> How are files connected?  I am using the default OMNIS data files, not SQL.  Are connected files similar to an SQL JOIN?
>>> 
>>> Mark
>>> 
>>> 
>>> On 1/30/2017 12:39 PM, BILL tube wrote:
>>>> Is it possible the account_no is in connected file ?
>>>> 
>>>> 
>>>>> On Jan 30, 2017, at 9:32 AM, Mark L. Wise <mark at alpha2.com> wrote:
>>>>> 
>>>>> I am in need (again) of help understanding some concepts with OMNIS7 coding.
>>>>> 
>>>>> Here is a code snippet;
>>>>> 
>>>>> ------------------
>>>>> Set main file {TRANSAC}
>>>>> Set search as calculation {ACCOUNT_NO=#S3}
>>>>> Set current list #L2
>>>>> Define list {TRANS_RSN,TRANS_SOR_RSN,INVOICE_NO,INV_SO}
>>>>> Calculate TRANS_SOR_RSN as 94294
>>>>> Build list from file on TRANS_SOR_RSN (Exact match,Use search)
>>>>> -------------------
>>>>> 
>>>>> What I don't understand is the use of the "Use search" modifier on the Build list from file (last line).
>>>>> 
>>>>> The Set search as calculation line uses a variable ACCOUNT_NO which is not contained in the file TRANSAC.  How can this be used as a search limiter if this field is not in the file?
>>>>> 
>>>>> Thanks again for any help you might give me.
>>>>> 
>>>>> Mark
>>>>> 
>>>>> --
>>>>> Mark L. Wise
>>>>> 
>>>>> Alpha II Service, Inc.
>>>>> 1312 Epworth Ave
>>>>> Reynoldsburg, Ohio 43068-2116
>>>>> USA
>>>>> 
>>>>> Office: (614) 868-5033
>>>>> Email: mark at alpha2.com
>>>>> WEB: www.alpha2.com
>>>>> 
>>>>> "People do not quit playing because they grow old; they grow old because they quit playing."
>>>>> 
>>>>> Oliver Wendell Holmes
>>>>> 
>>>>> Titles mean nothing.  The one with a servant's heart is the leader.
>>>>> 
>>>>> ---
>>>>> This email has been checked for viruses by Avast antivirus software.
>>>>> https://www.avast.com/antivirus
>>>>> 
>>>>> 
>>>>> _____________________________________________________________
>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>> 
>>>> 
>>>> _____________________________________________________________
>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>> 
>>> 
>>> --
>>> Mark L. Wise
>>> 
>>> Alpha II Service, Inc.
>>> 1312 Epworth Ave
>>> Reynoldsburg, Ohio 43068-2116
>>> USA
>>> 
>>> Office: (614) 868-5033
>>> Email: mark at alpha2.com
>>> WEB: www.alpha2.com
>>> 
>>> "People do not quit playing because they grow old; they grow old because they quit playing."
>>> 
>>> Oliver Wendell Holmes
>>> 
>>> Titles mean nothing.  The one with a servant's heart is the leader.
>>> 
>>> ---
>>> This email has been checked for viruses by Avast antivirus software.
>>> https://www.avast.com/antivirus
>>> 
>>> 
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>> 
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> 
> 
> -- 
> Mark L. Wise
> 
> Alpha II Service, Inc.
> 1312 Epworth Ave
> Reynoldsburg, Ohio 43068-2116
> USA
> 
> Office: (614) 868-5033
> Email: mark at alpha2.com
> WEB: www.alpha2.com
> 
> "People do not quit playing because they grow old; they grow old because they quit playing."
> 
> Oliver Wendell Holmes
> 
> Titles mean nothing.  The one with a servant's heart is the leader.
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com