Suggestions to set up a utilization tracking system FM10pro
Am trying to create a tracking db that incorporates monthly utilization (hours) for several serialized components (A through L) installed on similar types of serialized products upwards totaling around 40. My initial idea uses a table for each serialized component type (12 tables) , a new record for each month of usage per table, fields per record each record have a relationship back to a basic “entry” screen where a user enters utilization data. Upon entry, the previous month’s numbers get automatically updated across each field. After which we can then run reports and summary sheets.
Have tossed around the ideas of lookups and scripts to create new records and calculations, but before heading down that path wanted to probe whether there’s a better approach to this. Regards, John