Progress
AppBuilder
Developer’s Guide


Example: Assigning a New Sales Rep

This example illustrates how to use a SmartSelect instance to update the Sales–Rep field in a Customer record. The tables it uses are found in the sports2000 database.

Follow these steps, agreeing to all Advisor suggestions for links:

  1. Create a SmartWindow as the application workspace. Save it.
  2. Create the SmartDataObject master that will pump the Customer records. Choose the Customer table. Use only the Name, Address, City, and Sales–Rep fields from the Customer table. Save the master:
  3. Place into the application workspace an instance of the Customer SmartDataObject you just created:
  4. Create the SmartDataObject master that will feed the SmartSelect field. Choose the Salesrep table. Use only the Sales–Rep field from that table. Save the master:
  5. Create the SmartDataViewer master that will display the Customer records. Include all four of the fields. Save the master, but leave its workspace open:
  6. Place an instance of the Sales–Rep SmartDataObject into the master SmartDataViewer workspace:
  7. Replace the Sales–Rep field in the SmartDataViewer with a SmartSelect instance. Resize the instance for cosmetic reasons:
  8. Save the changes in the SmartDataViewer. Place an instance of the SmartDataViewer into application workspace:
  9. Place Navigation and Update SmartPanels into the application workspace:
  10. Run the workspace. You should be able to assign a new sales rep to any account by choosing from the combo box:

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095