3 Replies Latest reply on Feb 2, 2016 1:25 AM by Fahri Akar

    Copying records between tables

    RyanAshton

      Hi guys,

       

      More help needed.

       

      I'm quite happy with the progress I am making with my database - thanks to the community here for all your help in that regard.

       

      My database is for Estimates/Quotations.

       

      So I have the following tables...

       

      Screen Shot 2016-02-01 at 21.10.37.png

       

      And then I have this layout where I create the estimates with a portal linking to the "Estimate Data" table.

       

      Screenshot 2016-02-01 21.24.37.png

       

      I can enter info fine into the portal and it saves in the "Estimate Data" table. I also want whatever is entered to "copy" to the "Product Data" table and be stored there for future use.  Then when I start a new estimate, and click on the "Brand" field in the portal, I want the "Drop-down List" to link to the Product Data and pull in all the associated fields from there to the related records in the new estimate and into the "Estimate Data" table.

       

      How do I go about doing that?

       

      Thanks in advance.

       

      Kind regards,

       

      Ryan