Relationship Examples
cm_mstr to so_mstr Relationship Example shows that one customer can have zero or more sales orders and that one sales order has one and only one customer.
cm_mstr to so_mstr Relationship Example
To join these two tables within Progress, you would set so_cust equal to cm_addr or vice versa.
FOR EACH cm_mstr EACH so_mstr WHERE so_domain = cm_domain AND cm_addr = so_cust:
DISPLAY cm_addr so_nbr.
END.
so_mstr to sod_det Relationship Example shows that one EMT sales order can have zero or more sales order details and that one sales order detail has one and only one EMT sales order.
so_mstr to sod_det Relationship Example
To join these two tables within Progress, set so_nbr to sod_nbr.
FOR EACH so_mstr EACH sod_det WHERE so_domain = sod_domain AND so_nbr = sod_nbr:
DISPLAY so_nbr and sod_nbr.
END.
