Skip to content

Creating the Order Entry View

The Order Entry View is the main view of the program and also the most complex view. You will create the view with the Data Entry View Wizard, and then complete it in the Studio. You will probably need to move some fields around, change their sizes, and do some re-alignment. How you arrive at it isn’t important, as long as the end result is correct. Feel free to experiment with different features of the Studio to try to accomplish your goal.

Steps to Create the Order Entry View

  1. Click on the Create New button on the Studio’s toolbar.
  2. Click on the View / Report tab of the Create New... dialog.

  3. Double-click the Data Entry View Wizard icon.

  4. Read the explanations on the first wizard page of what this wizard will do and click Next.

  5. On the Names wizard page, enter OrderEntryView as the object name, OrderEntryView as the filename, and Order Entry View as the description. Then click Next.

  6. On the "Entry View Style" wizard page, select Create a Header Detail Entry View, then click Next.

  7. On the "Child Data Dictionary" wizard page, click on OrderDetail - OrderDetail_DataDictionary to select it as the data dictionary to be used, then click Next.

  8. On the "Header Data Dictionary" wizard page, click on OrderHeader - OrderHeader_DataDictionary to select it as the data dictionary to be used, then click Next.

  9. On the "Header/Form Entry Fields" wizard page, using the Add button, add the fields as shown in the image below in the order they are shown. If you want to add all of the fields from one table at a time, you can do so, then use the Move Down and Move Up buttons to put them in the correct order in the list. Click Next when all the fields are added and in the correct order.

Adding Parent Fields vs. Child Fields

The fields that we tell you to add are, if they are part of a relationship, always the related-to field from the parent table. If you use the related-from fields from the child table instead, the wizard(s) will automatically substitute the parent field for you, which is almost always the field that should be used.

  1. On the "Detail/Grid Entry Fields" wizard page, add Item_Id, Description, and Unit_Price from the Inventory table, followed by Price, Qty_Ordered, and Extended_Price from the OrderDetail table. The completed list should look like the image below. Click Next.

  1. On the "Labels, Alignment and Preview" wizard page, make these adjustments on the Header/Form Fields tab page:
  2. Check the checkboxes in the Same Line column for fields Customer Number, Order Date, Ordered By, State, Zip/Postal Code, Sales Person Id, and Ship Via.
  3. Change the Label of City to City/State/Zip and remove the labels State and Zip/Postal Code.
  4. Change the Label Justification radio from Left to Right.

There are no adjustments needed on the "Detail/Grid Fields" tab page.

  1. Click on the Preview button and ensure that your view looks like the one below.

  2. Click Finish on the last wizard page.

You should now be back in the Studio, with the newly created Order Entry View open in the visual designer.

Next Step

Customizing the Order Entry View