Really struggling with this look up field
I have a Shift Throughput table (STP) that gets input each shift regarding production details.
One field that is in each STP record is Electrical Usage which is dependent on the equipment used.
I have a Mill Table which contains a list of the equipment available and the electric used for that equipment.
I would like to have the electric usage auto fill on each STP record once the equipment is selected for that Invoice_ID ( the primary key field for each production run). Also I need the electric to stay with the record even if the equipment changes during the run.