AnsweredAssumed Answered

Really struggling with this look up field

Question asked by gjbdjc on Sep 26, 2014
Latest reply on Sep 26, 2014 by philmodjunk


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.