and i have set up a layout based on items required, with a portal in the header - see screen shot below. the portal being the related records in the table production weight required. see screenshot below - but even though there are 20 related records, i still get a blank for my calc. Any ideas ?
the last screen shot shows the calcs :-
Your relationship is:
items required:delivery date =production weight required :delivery date
items required :: recipe = production weight required::Product Required
I must assume that your screen shot of the layout shows a list view layout based on Production Weight Required with a portal in the header based on Items Required. Correct? (the layout name suggests the opposite, but the fields seem consistent with my guess here.)
But that makes the portal in the header confusing as this appears to be a one to many relationship of Production Weight Required to Items required so the portal should never show more than one related record...
If I have that correct, then Sum ( items required::total weight of items required )
seems reasonable, but I'd check this from a layout based on Production Weight Required with a portal to items required to see what is shown.
and what type of field is "total weight of items required"?