Lesson 3: Using the CustDB client application

Both the consolidated and remote databases contain a table named ULOrder. While the consolidated database holds all orders (approved and those pending approval), the UltraLite remote database only displays a subset of rows according to the user that has authenticated.

Columns in the table appear as fields in the client application. When you add an order, you must populate the Customer, Product, Quantity, Price, and Discount fields. You can also append other details such as Status or Notes. The timestamp column identifies whether the row needs to be synchronized.

Browse orders

Browsing orders is accomplished in a similar method for each version of the UltraLite client application. By browsing an order, you are scrolling through the data in your local UltraLite database. Because customers are sorted alphabetically, you can easily scroll through the list and locate a customer by name.

To scroll down the list of customers, click Next.
To scroll up through the list of customers, click Previous.

Add an order

Adding an order is carried out in a similar way in each version of the UltraLite client application. By adding an order, you have modified the data in your local UltraLite database. This data is not shared with the consolidated database until you synchronize.

Click Order » New.
In the Customer list, click Basements R Us.
In the Product list, click Screwmaster Drill. The price of this item is automatically entered in the Price field.
In the Quantity field, type 20.
In the Discount field, type 5 (percent) and click OK.

Approve, deny, and delete orders

Because you have authenticated your identity as user ID 50, you are a manager that can perform all the same tasks as a sales person, but you have the added ability to accept or reject orders. By accepting or rejecting an order, you are changing the status of it and adding an additional note for the sales person to review. However, the data in the consolidated database is unchanged until you synchronize.

Approve the order for Apple Street Builders.
1. To locate the customer, click Previous.
2. To approve the order, click Order and then Approve.
3. In the Note list, click Good.
4. Click OK.
  
  The order appears with a status of Approved.
Deny the order for Art's Renovations.
1. Go to the next order in the list, which is from Art's Renovations.
2. To deny the order, click Order and then Deny.
3. In the Note list, click Discount Is Too High.
4. Click OK.
The order appears with a status of Denied.
Delete the order for Awnings R Us.
1. Go to the next order in the list, which is from Awnings R Us.
2. Delete this order by choosing Order » Delete.
  
  Click OK to confirm the deletion.
  
  The order is marked as deleted. However, the current data remains in the UltraLite remote database until you synchronize changes to the consolidated database.