Write value to table from another table

[agelo12]

Hello!


I want to automatically write the value from the table tbl_Equipment in the field hours in the table tbl_Characteristic in the hours the same column.




Thank you in advance!

[xps35]

Why do you want to store the same value twice? Usually that is a bad idea.

[agelo12]

Thanks for the reply!
Because I will need to calculate the next service.



Thank you in advance!

[xps35]

You find the hours in the parent record. There is no need to store the hours in every child record. Make a query joining the two tables and make the calculation. There is no need to store the result. You can show it in the query.

[agelo12]

I can't find it unfortunately, can you help?

Database_22_12_24_1.zip

[xps35]

I will look at it later today

[agelo12]

Thanks you!

[xps35]

Please look at my example. If you have any questions about it, feel free to ask them.

[agelo12]

Amazing job, xps35!
Thank you for your time!

Best regards!