AnsweredAssumed Answered

Populate fields from another table where a key field matches

Question asked by DianeBrabers8092 on Sep 1, 2011
Latest reply on Sep 2, 2011 by philmodjunk

Title

Populate fields from another table where a key field matches

Post

I have two databases; Projects and Standard Costs.  Both the Projects and The standard costs database have the following fields:

Project value

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.

Outcomes