Release 10.1A: OpenEdge Development:
AppBuilder

> ## 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.

> | To use a SmartSelect instance to update the Sales-Rep field in a Customer record (agree 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095