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...
And then I have this layout where I create the estimates with a portal linking to the "Estimate Data" table.
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.