home *** CD-ROM | disk | FTP | other *** search
-
- Problem This was the Lotus contest winner and rightly so. Most
- sophisticated Symphony application in library. Its an menu-
- driven order entry system. Uses 3 databases, one for orders,
- one for parts, and one for customers. To create an order, you
- simply type in customer number, part number, and qty ordered.
- It fills in the rest from the other two databases automatically.
-
-
- Block Diagram
- ________________ ____________ ___________ ___________ __________
- | | | Part# | Customer |Prt# & Cus|
- |Order Entry Form| Criteria | Database | Database | Form Defs|
- |________________|____________|___________|___________|__________|
- | | |
- |Form Definitions| |
- |________________| Macros |
- | | |
- |Order Database | |
- |________________|________________________|
-
- Tips
- Order entry form definitions worth much study.
- Three fields use validity checks, F37, F47, and F50.
- Several calculated fields which pull info from other databases.
- Default value in date field is todays date.
-
- Macros suppress Control-Break key.
- Extensive use macro and window mgmt routines.
- Demonstrates how to build or define own macro commands such
- as {won} for {windowson} W61..X67
- Self modifying string macros R106
-
-
-
-
-
-