BPM - set the specified field of the changed row to the specific

Here is an example of setting a checkbox on PODtl = to a checkbox on JobOper. Obviously you must link the tables in a logical way if you want to set fields equal to other fields of linked records.

For Each ttPODetail no-lock.
Find First PODetail Where ttPODetail.PONum = PODetail.PONum AND ttPODetail.POLine = PODetail.POLine no-lock.
Find First PORel Where PODetail.PONum = PORel.PONum AND PODetail.POLine = PORel.POLine no-lock.
Find First JobHead Where PORel.JobNum = JobHead.JobNum no-lock.
Find First JobAsmbl Where JobHead.JobNum = JobAsmbl.JobNum AND JobAsmbl.AssemblySeq = PORel.AssemblySeq no-lock.
Find First JobOper Where JobAsmbl.JobNum = JobOper.JobNum AND JobOper.AssemblySeq = JobAsmbl.AssemblySeq AND JobOper.OprSeq = PORel.JobSeq no-lock.

IF PORel.TranType = 'PUR-SUB' THEN

DO:
Run lib\UpdateTableBuffer.p(input BUFFER PODetail:HANDLE,'CheckBox03',JobOper.CheckBox03).
END.

END.

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Hi,
>
> I have a BPM that updates a field to a specific expression.
> Right now, the specific expression is just a hard coded value.
>
> Is it possible to populate the ttTable/field with an expression that uses a value from another table?
>
> Thanks
>
Yes there is simple do a foreach row in ttTable find tagetTable assign
ttTable.Field = targetTable.Field


*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com> <http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*



On Wed, Dec 15, 2010 at 1:27 AM, cooner_55421 <cooner_55421@...>wrote:

>
>
> Hi,
>
> I have a BPM that updates a field to a specific expression.
> Right now, the specific expression is just a hard coded value.
>
> Is it possible to populate the ttTable/field with an expression that uses a
> value from another table?
>
> Thanks
>
>
>


[Non-text portions of this message have been removed]