Let's say I have 1000 boxes of widgets. I need to generate a report that shows the box number, TOTAL value and cost for each box.

Included fields:

box number

quantity per box

extended price per item (quantity x price)

extended cost (quantity x cost)

I am not a script person, but I assume it requires a lookup and some sort of "sum" calculation. I am hitting the wall on how to find all the boxes and run the calculations on each one.

Any thoughts? Thanks in advance.

s

Not really a script; in addition to your data fields, you need calculated fields. Look into FileMaker Invoice or Estimate Sample solution; the Invoice layout and its fields and related fields have such total, grand total, total per line fields defined. You will be able to design the calculation fields you needs using these as an example.