How to do a Calculated result
I have a table called "stock" and a table called "Production". When im in my stock layout i have a button set up to select the id of said stock, copy, and take it to the production layout where it pastes into a id field there. The "stock" table has some other fields i want to auto import. I have fields setup in the production layout called item, color, and size, how would i set those fields to auto calculate the corresponding record from "stock" based on the id number copied over?