Is there a way to select which script to perform based upon the results of a calculation.

For my cabinetshop I have various scripts that are germane to specific cabinet styles.

Script B6, for example, lists all the parts for cabinet style B6. Script B5 lists all the parts for cabinet style B5, etc.

Is there a way to have scriptmaker call a specific script based upon the particular contents of a field?

Simply put, yes. If you're wanting the script to run automatically upon selection of cabinet style then you might want to set a script trigger. Your script would then evaluate the results of Cabinet Style and then perform the appropriate subscript based on 'if' flow control statements.

The problem with this approach might be that you seem to have a new script for every cabinet style. It would be preferable to a have a single generic script that does the task for any cabinet style. This may be accomplished by passing the cabinet style as a script parameter and then use this to perform searches for all the necessary components.

Mfero,

Thanks for your input.

I have been hammering at this database for some time now.

I finally have the architecture sorted out so I am now in the process of a re-write.

Essentially the project consists of a series of components that you can mix and match to produce different cabinet outcomes. The components all share a range of attributes (cross-grain dimension, with-grain, thickness) They also contain status attributes (next, complete) In this respect the math is also linked to the production management.

To date I a have been assembling these cabinets using an a Masterscript that activates sub-routine scripts.

I have used scriptparameters in combination with buttons before for timekeeping functions. In that case I used fields themselves as the script button object. Clicking button 1 pulled the contents of field 1 (which contained a unique worker name). The script then performed a search for that worker name.

I have to think about this for a bit.

Thanks for the direction so far.