AnsweredAssumed Answered

Auto-populate new Estimate with standard Items

Question asked by FranzLang on Dec 10, 2010
Latest reply on Dec 13, 2010 by philmodjunk


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...