Foreign key hyperlinking added to Show Table and Show Record

Foreign key hyperlinking added to Show Table and Show Record panels

Hyperlinks are added to foreign key fields in Show Table and Show Record panels when creating a new applications. These links go to their associated Show Record and Edit Record pages.

Migration effects

None. Your application is not modified.

What you should do

You can manually add foreign key hyperlinking to your application’s existing Show Table and Show Record panels.

Step 1: In the Design tab in Iron Speed Designer, double-click the field you wish to hyperlink. The Properties dialog is displayed.

Step 2: In the Properties dialog, set the Display Style to ‘Link Button’ in the Display tab.

Step 3: Set the Display Style Options to ‘Redirect’.

Step 4: Set Action After Command to ‘Go to a specific URL’.

Step 5: For the URL, specify the appropriate Show Record or Edit Record page. For the URL parameters:

Set the URL parameter name as the name of the foreign key table.
Select the corresponding table or record control name from the ‘Data value from’ drop down list.
Select the ‘Foreign Key’ radio button and choose the corresponding foreign key field.

Step 6: Finally, click ‘OK’ to close the Properties dialog.

Step 7: Build and run your application.