3 Replies Latest reply on Sep 2, 2011 8:53 AM by philmodjunk

    Populate fields from another table where a key field matches

    DianeBrabers8092

      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.