Calculate yearly usage on layout
FM Pro10 & 11, Server 11. Network shared Windows system, XP & Vista. 10 users
I am trying to work out parts usage over the year for individual parts.
I have a 'Parts_Inventory' table and a 'Job_Card' table, joined by a 'Parts_Usage' table. Part Number and Job Card Number are the foriegn keys in the usage table.
What I would like to be able to do is display for each part number in my Inventory layout, the quantity used so far this year and in another field, the quantity used total last year.
Can this be done with live calculations rather than having to produce a grouped report?