Putting it All Together: A WordPage Tutorial
In this section we’ll go step by step through the creation of a moderately complex WordPage application. This application will show salesperson information from the NorthWind sample database provided with Microsoft Access.
When we’re done we’ll have three documents. The first document shows the results of the query. The second is a frameset that is a container for the other two documents. The third is a page that gives the user data entry fields for filtering the query by order date, salesperson, and amount. This example assumes that you are running Word 2000 starting a new document.
Create a datasource
1. Select “Insert data source” from the WordPage menu
2. WordPage launches the wizard for creating a new datasource.
3. Click the “Select database” button to launch the database selector.
4. Select the Jet 4.0 OLE DB Provider and press Next
5. Press the “Select tables to use” button to launch the table editor.
6. In the table editor add the Orders table.
7. Add the Employees table as a child of Orders.
8. Add the Order Details table as a child of Orders.
9. If you make a mistake use the arrow buttons to rearrange the tables or the “Delete” button to remove a table until your screen looks like the example above. In this example WordPage can automatically determine the join condition. If you see any red text in the list it means you need to rearrange the tables. When the table list is correct all of the red text will go away.
10. Press OK to close the table editor.
After you press Finish in the new datasource wizard your document should look like this:
