"The program allows us to save a great deal of valuable time by automatically importing images, style sheets and formatting. This allows us to be more competitive in the marketplace and therefore more successful in our business "

– Antiques Trade Gazette

The Form Design Wizard

The Form Design Wizard is essentially a drawing program which allows you to design your your data entry forms. To open it, click on the Setup button on the main window and choose Form Design Wizard from the popup menu.

form design wizard

Yours might look a bit different - it may have objects already placed on it..

Pages

Each data entry form can consist of any number of pages. In the example shown here, the form has three pages named Details, Description, and History. These are shown as tabs across the top of the form and in a list on the right of the form:

pages

You can:

To view the layout for a different page, click on it either in the tab or in the Pages list.

Adding Objects to a page

On the right of the window you'll see a list of all the fields in the selected table and another list named Other Objects (see below for an explanation of the Other Objects) . To place a field or other object onto the page, drag and drop it into position. Once an object has been placed on the form, it can be moved and resized.

Note that some objects will have additional objects associated with them. For example, if you place a field that has been designated as a Picture field, it will have two buttons with it:

picture field

These associated objects will stick together and will automatically move if you move the main object.

Moving and resizing objects

  1. Select the object
  2. It will then have a number of "handles":

object

  1. To move the object, drag it to a new position
  2. To change its size, select one of the handles and drag it

Aligning Objects

It can be a bit tricky to get your objects neatly arranged on the page, so you can use the Alignment tools to help:

alignment tools Align left; align center; align right
Align top; align center; align bottom

To use the Alignment tools, first select the objects you want to align (hold down the Shift key to select multiple objects), then click on the appropriate alignment button. For example, here are "before" and "after" pictures showing a few fields being aligned on the left:

 

Setting the Data Entry Order

The data entry order is the order in which your cursor will move from object to object when you are entering data. The default order is the order in which the objects were placed on the form, but you might want to change this if you've added more objects or moved them around. To see the current data entry order, click the Show Data Entry Order button. CatBase draws arrows between the objects to indicate the order:

data entry order

Maybe this isn't what we want - it would be better to go from the Name to the Item No. and then to the Price. To change the data entry order:

  1. Click on the Set Data Entry Order button
  2. Double-click on the first object (the Name field, in this example) - it will appear selected
  3. Double-click on the next object - the Item No. field in this example. An arrow will be drawn from the first object to the second one
  4. Carry on double-clicking on the objects in the order you want to go
  5. If you make a mistake, click on the Set Data Entry Order button twice and start again
  6. To save your new order, click once on Set Data Entry Order

Other Objects

In addition to fields, there are various other objects that can be placed on data entry forms. These include:

In this example, the Options table is related to the Product table:

included list

When you are adding or modifying a Product record, the included list looks like this:

included list

You can change the columns that appear in your included lists: to do this, click on the Setup button on the main window and choose List View Wizard.

Saving your form

When you're happy with the layout of your data entry forms, click on the Save button.

Got any questions? Contact us!
About Us | Site Map | Privacy Policy | Contact Us | Affiliates | ©2011 CatBase Software Ltd.