Summary
Important Observations
- This application is not intended to represent the best user interface for this type of "header and detail" update.
- SELECT_SQL can be used to create powerful and flexible search logic for reading tables.
- Group boxes enable related data and objects to be visually grouped on the form.
Tips & Techniques
- Always use interactive SQL to test your proposed logic over your database platform.
- To use SELECT_SQL effectively you need a good knowledge of SQL. To gain more SQL knowledge, search for SQL in the Technical Reference Guide.
What You Should Know
- How to write a simple "header/detail" update form.
- How to use the Multi-line edit box control.