I've read through a ton of threads on global fields, variable setting
etc. I can't get my head around the logically way to get related data
into a layout. I've tried setting up a table where fields are
calculated based on data pulled from global fields in each of the
other tables. How and where should I script the global field to
update based on a the "product" record active in the Product layout?

The only way I am able to get the related data is if I go down. I
haven't been able to go up through the relationship unless I require
the user to make a selection for that portal. Driving me nuts.



Relationships:

CustTable:
CustID
CustName

relationship--CustomerTable:custid (one) = OrderTable:custfk (many)

OrderTable:
OrderID
OrderPO
custfk
G_ID_PO (global calc: orderid & "_" & orderPO)

relationship-OrderTablerderid (one) = OrderDetailTablerderfk
(many)

OrderDetailTable:
OrderDetailID
OrderMasterCartonID
OrderQty
Orderfk
G_OrdD_MC (global calc: orderdetailid & "_" & ordermastercartonid)

- relationship OrderDetailTablerderdetailid (one) =
MasterCartonTablerderdetail_fk (many)

MasterCartonTable:
MasterCartonID
MasterCartonName
orderdetail_fk
Product in MC (pop up from value list pulling from product table field
- ends up listing all...will get very lengthy!! UGH!)
G_MCID_MCName (global calc: mastercartonid & "_" & mastercartonname)

-relationship MasterCartonTable:mastercartonid (one) =
ProductTable:mastercartonfk (many)

ProductTable:
ProductID
ProductName
mastercartonfk


Creatively,
CarpeFlora
"Sieze the Beauty"