Ensure that the Employee ID field is 50, the Host field is 10.0.2.2, and the Port field is 80, and then click Save.

The application automatically synchronizes and a set of customers, products, and orders is downloaded to the application from the CustDB consolidated database.

In the simulator, click Menu » New.

In the Customer field, choose Ace Properties.

In the Product field, choose 4x8 Drywall x100.

In the Quantity field, type 999.

In the Discount field, type 25.

Click OK to add the new order.

Synchronize the application with the CustDB consolidated database.

In the simulator, click Menu and then click Sync.

Connect to the CustDB consolidated database with Interactive SQL.

Verify that the synchronization was successful.

Execute the following SQL statement in Interactive SQL:

SELECT order_id, disc, quant, notes, status, c.cust_id, 
    cust_name, p.prod_id, prod_name, price 
  FROM ULOrder o, ULCustomer c, ULProduct p 
  WHERE o.cust_id = c.cust_id 
  AND o.prod_id = p.prod_id 
  AND c.cust_name = 'Ace Properties'
  AND p.prod_name = '4x8 Drywall x100';

Synchronization was successful when an order entry appears in Interactive SQL.

Close the simulator window.