Not sure if the title makes sense or not, but here is what I am wanting to do and not sure if it's possible:
I have a Trading Partner Profile file. In this file, I will to put the constants and/or fields that should be used to populate another file.
Example:
TPFile
Test1 field can have one of these value: ASN#, INV#, PO#, DELIVERY#, PICKTICKET#
Key field is Account#
I want to be able to chain to the TPFile
Retrieve the value within the Test1 field and use that value as the field name for populating the HEADERFile
HEADERFile field for sample purposes REF01
Chain '12345' TPFile; //Test1 is populated with 'PO#'
if %found(TPFile);
REF01 = PO# //this PO# field would be the field name within the SHIPMENTFile
endif;
I hope I make sense in writing this and not a clue if possible.
Just trying to find a way to eliminate a bunch of IF or SELECT statements in my program and put the data in a TPFile.
Thanks
I have a Trading Partner Profile file. In this file, I will to put the constants and/or fields that should be used to populate another file.
Example:
TPFile
Test1 field can have one of these value: ASN#, INV#, PO#, DELIVERY#, PICKTICKET#
Key field is Account#
I want to be able to chain to the TPFile
Retrieve the value within the Test1 field and use that value as the field name for populating the HEADERFile
HEADERFile field for sample purposes REF01
Chain '12345' TPFile; //Test1 is populated with 'PO#'
if %found(TPFile);
REF01 = PO# //this PO# field would be the field name within the SHIPMENTFile
endif;
I hope I make sense in writing this and not a clue if possible.
Just trying to find a way to eliminate a bunch of IF or SELECT statements in my program and put the data in a TPFile.
Thanks
Comment