We manufacture metal parts on CNC machines.
Each product is made by means of several technological operations.
There is an application “Production of products”, containing tables:
№1. 1. “List of manufactured articles”.
№2. 2. “Journal of technological operations”.
After each technological operation is performed, a new record is created in the “Journal of technological operations”. (table 2.)
In the new record is entered:
- id Products from Table No. 1. ( to the column [Product] ).
- number of the executed operation ( in the column [Operation] ).
When creating each new record in Table No. 2. , copy from it the number of the executed operation in Table No. 1. ( in the column [Current operation] ).
Thus, each executed operation updates the [Current operation] column in Table No. 1 for the corresponding product.
What I was able to do: when adding a new entry in Table No. 2. update the [Current operation] column in Table No. 1. to the text value “Updated”.
Please help: How to add the operation number from Table No. 2 instead of the text value. ?
Translated with www.DeepL.com/Translator (free version)