So I'm working on updating a table for production records at my cheesemaking plant. There a number of production steps where the same three things (time, temperature, pH) are recorded. I'd been doing these as fields, but the cheesemakers keep adding steps -- and since I have to add three fields for every step it's getting painful to keep up the table and layouts. It occurred to me that I could create a Steps table and then a Steps Ledger join table, as so:
However, I also have a reoccurring calculation where I need to find the difference between two steps, and I'm not sure how I'd create that calculation with this setup. As an example: I have a step called "Starter Added" and a step called "Rennet Added". The cheesemakers want to know how much time passed between adding the starter and adding the rennet. In my current setup I just add a calculation field (Rennet Added Time - Starter Added Time), but if each of these was an entry in Cheesemake Steps with their times for a specific date stored in the Make Step Ledger, I'm not sure how to fetch that number.
Help much appreciated, even if it's just telling me to suck it up and stick with the ever-expanding list of fields.