Kbase 15716: Results : Creating a multiple table update query form
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
Results : Creating a multiple table update query form
Even though Results is mainly a reporting tool it can be used to
generate simple updateable browsers. With such a browser the user can
add, delete and create records in the database (assuming the Progress
license allows this as well). Both the character and GUI methods
are covered here.
Character mode:
1.) Create a query form for each table that you want to browse.
2.) Choose Query from the Main Menu.
3.) Select the query to use for the Master Record browse.
4.) Select Join from the menu bar.
5.) Select the query to use as the Detail Record browse.
6.) The query forms are displayed in two separate frames with focus on
the Detail Record frame (focus cannot be given to the Master Record).
GUI Mode:
1.) Create a query form that references both tables that you want to
browse (the tables are not updateable at this point).
2.) From the menu bar select Options.Mater-Detail.
3.) A "Break Point" menu is then presented.
Select "Between <table1> and <table2>" where <table1> is the name of
your Master Record and <table2> is the name of your Detail Record.
4.) The records are broken out into two separate updateable browsers
that share a Master-Detail relationship.
Progress Software Technical Support Note # 15716