You can link up tables that have relational aspects.
Simply put this means if you had a table that listed famous painters and their biographies.
You could then have a related table that listed the paintings that each had done.
On this page, you can specify which fields in your table contain fields that cross reference in other tables.
You can skip this page in ASaP if you have no need to relate tables.
REMEMBER: If you choose to have relations between tables, you will need to go back and create additional projects for each of the other tables. This is because the relative fields will be generated with hyperlinks expecting to link to relative information in the other set of generated pages. Make sure when creating the pages for the other table you MUST supply the common field between the two tables on the SEARCH FORM.
Keep in mind that this is usually used when you have two tables, each of which you're generating Web pages for, that have some field in common, and thereby "relate." This is done in steps.
On the Relations screen, first, select the name of the field in your table that you want to relate with another table.
A second list will appear. From it, select the name of the "foreign" table. (You either have or will be generating ASP pages for this table as well in another project.)
From the third list that appears, choose the name of the "foreign" field. This field should somehow relate to (contain the same kind of information as) the field in the table you're currently building a project for, the field you selected in the first list.
Click the "Add Relation" button to add this relation to your list of relations for this table. The list of relations will appear in the lower right corner of the Relations screen. On your generated detail page, each of these relations will appear in the form of a hyperlink at the bottom, allowing the person browsing the Web page to immediately search for records containing the same information in other, related tables.
You can remove a relation by clicking on it in the list of relations. Be sure this is what you want, as the relation will be removed without prompting you. If you need to reorder your relations, you can delete those which you want to appear later in the list and re-add them later in the list.
New in version 3.1.40 you can view the related table information in what's called an "iframe" (inline frame). This makes it possible to pull the related table information into the same page so that they can be viewed along with the current information. ASaP now defaults to putting your related information into the iframe and if you wish you can choose to have a link instead.
An example of an iframe is displayed below where the artist's biography page displays the individual paintings from the related table on the same page.
In this example the painting titles have links then that show the details of the paintings along with a small image. This information is displayed in a popup window when you click on one of the titles. When building the pages for the related table if you choose to use the iframe option you will then need to specify the popup options which can be found on the "Design Options" page within ASaP.
