Copying records between tables

Discussion created by RyanAshton on Feb 1, 2016
Latest reply on Feb 2, 2016 by Fahri Akar

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,