Linking Forms - Hints & Problem Solver

Establishing Links with your Own Database Tables

You may have created your own database table via the Card File system and you happen to know that the field ACCOUNT in this card file contains supplier account information. In order to link this to the SUPPLIER database table you would have to create a "join" as described above. For this to work properly:

• The field in the Card File database table would have be of the same type and length as CODE (the account code field) in the SUPPLIER database table.

• You must sort the CODE field in the Card File. Select an Ascending Order Sort.

Assume your Card File database table is called MYINFO. To "join" MYINFO to the supplier database table you would:

1. Specify MYINFO as the Main table on the Link Dialog.

2. Enter: Supplier->Code as the Database + Key.

3. Enter: Account as the Joined By field.

Opening Tables Without Joining Them

You can open a table without joining it to the main table or any other linked table by entering # in the Joined By field. This would be useful if you intend to access different areas of the table using special CAPITAL Business Script instructions.