Changing Foreign Key Property
You can view or change the Additional Properties of a foreign key only while editing the constraint. You can alter the following properties of a foreign key.
Property | Description |
Caption | You can specify a name for the foreign key column. |
Display Length | Display length of the foreign key value. |
Show In Filter | Whether to show the foreign key column in the filter screen. |
Hide In Display Screen? | Whether to show the foreign key in the display grid. |
Show in Report? | Whether to show the foreign key column in the filter screen. |
Name | |
To change foreign key property
1. On the Menu toolbar, click Define > Objects and select the object in which you want to change the foreign key property.
2. Select the Structure tab.
3. Click Edit Constraints.
4. Click the Edit icon next to the required foreign key.
5. In the property Related Column Description click the icon.
6. In the pop up, click Additional Properties.
7. Make the required changes and click Save Values.