Hello everyone, I'm sort of a newbie to filemaker, and I made this relationship diagram that I am wondering if it is actually constructed correctly.  I have a number of items that are priced differently in different outlets.  I am trying to "audit" the daily transactions for each item, with daily sales totals and inventories.  Any advice would be appreciated.

Have a look at this model, which also features a critical piece missing from your setup – a line items / sales item table.

I am trying to "audit" the daily transactions for each item, with daily sales totals and inventories.​

Usually you should be able to derive such data from that line items table; e.g. find sales by date, then use the related set of item transactions to generate those figures, by sorting and summarizing in an appropriate list layout.

Edited May 30, 201511 yr by eos

Hi Eos, your model looks much better than my initial diagram, muchos gracias