Hi Dan,
You'll need to use a 4GL code Action to do this but you'll probably have to carry out the rest of the BPM in 4GL then. I would use a post-processing directive and this would be the start of the code:
find first ttShipHead where ttShipHead.ShipStatus="Shipped" no-lock no-error.
if available ttShipHead then do:
find first ShipDtl where ShipDtl.Company=ttShipHead.Company and ShipDtl.PackNum=ttShipHead.PackNum.
if available ShipDtl then do:
DEFINE VARIABLE OrdNum AS INTEGER NO-UNDO.
OrdNum = 0.
OrdNum = ShipDtl.OrderNum.
FOR EACH OrderDtl WHERE (OrderDtl.OrderNum = OrdNum) and (OrderDtl.Company = ttShipHead.Company) no-lock:
< Place code here >
end.
What exactly are you trying to do? You mentioned an alert template - are you trying to send an email if some criteria is breached? Let me know if I can help you with any of it.
Nigel.
You'll need to use a 4GL code Action to do this but you'll probably have to carry out the rest of the BPM in 4GL then. I would use a post-processing directive and this would be the start of the code:
find first ttShipHead where ttShipHead.ShipStatus="Shipped" no-lock no-error.
if available ttShipHead then do:
find first ShipDtl where ShipDtl.Company=ttShipHead.Company and ShipDtl.PackNum=ttShipHead.PackNum.
if available ShipDtl then do:
DEFINE VARIABLE OrdNum AS INTEGER NO-UNDO.
OrdNum = 0.
OrdNum = ShipDtl.OrderNum.
FOR EACH OrderDtl WHERE (OrderDtl.OrderNum = OrdNum) and (OrderDtl.Company = ttShipHead.Company) no-lock:
< Place code here >
end.
What exactly are you trying to do? You mentioned an alert template - are you trying to send an email if some criteria is breached? Let me know if I can help you with any of it.
Nigel.
--- In vantage@yahoogroups.com, "Dan Shallbetter" <dans@...> wrote:
>
> Hello Nigel,
>
>
>
> Yes, I meant to say selling price. Having only done 1 BPM, how do I link tables together in 1 BPM?
>
>
>
> Thanks,
>
>
>
> Dan
>
>