Auto-populate new Estimate with standard Items
I just built myself a database to produce Estimates more rapidly than before.
Each Estimate can contain multiple Items, so I added a Join Table to link the two tables (which I assume is right).
I am quite happy with it so far and it works quite well :-)
There's only one thing left:
Each new Estimate I create usually contains a handful of standard Items, i.e. Items that I use repeatedly in almost all my estimates. It is quite tedious to add all these Items manually each time I create a new Estimate.
Now is there a way to fill a new Estimate with those standard Items at the click of a button?
When I click the button, I want the Estimate to be populated with references to Items #1, #2, #3, #4, and #5.
I figure that this should be done with a script but I lack the experience to do this by myself. I have already tried a couple of things, but to no avail.
Can anybody help? What would a script have to look like?
Thanks a lot...