Populate fields from another table where a key field matches
I have two databases; Projects and Standard Costs. Both the Projects and The standard costs database have the following fields:
Fase 1 prijs
Fase 2 prijs
Fase 3 prijs
I would like to write a script that will automatically populate the values of Fase 1, 2 and 3 in the Projects database from the Standard Costs database where the vaule of Project value matches in both databases.
Thanks for your help.