My previous post on this question didn't seem to post.
I have a recipe table that contains a product code as a text value. It also contains the recipe I'd number.
I have a product log table.
One of the entries in the product log table is the recipe id number.
What I would like to happen is when I create a new log entry and enter the recipe id no in the log the product code is imported into the product log table.
I have posted a question on how to do this.
My question
How can I automatically combine the product lot no and the product code to form a final product code?
Example
Lit No 300
Product Code CU.WM.SS
Final Product Code 300.CU.WM.SS
Thanks