Setting up a new database model

Before you begin

Before you start building models, you should review the information discussed in Planning a model.

To set up a new database model:

1. On the Database menu, click Models. The Model window opens.
2. In the Model window, click [Add].
3. Complete the Model and Description fields. You can use [Copy] and [Prefill] for this purpose.
4. (optional) Click to open the Default Display Options window where you can define:
   • The font to use throughout your model.
   • The default fields and help notes to display for the model during takeoff.
5. As you build the model, you can:
   • Add text. How?
   • Add questions
   How?

   Adding a look up question to a model

   Add a numeric question to a model

   Add a yes/no question to a model

   Connecting a look up question to an item or assembly variable

   Connecting a numeric question to an item or assembly variable

   Connecting a text question to an item or assembly variable

   Using a yes/no question to display or hide an item or assembly line

   • Add items and assemblies
   • Edit an item, assembly, or variable database record
   • Enter default values
   • Set up logic to include or exclude a line during takeoff. How?
   • Improve the appearance of the model. How?
6. Review the model and make changes as needed.
7. When you finish setting up the model, click [OK] to save it.
8. Set up additional models in the same manner. When you finish, click [Close].

Published: July 07, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks