Page History

...

As long as a field is not created from another referenced field, any field can be used as a reference field.

Once a field is defined as having a reference field, LANSA allows you to selectively copy rules, triggers and help text from the referenced field. You can copy this information when the field is created and you can also selectively copy these details after the field has been created.

A reference field does not adopt the visualizations of the referenced field.

If a prompt function is specified for a reference field, the prompt function will be available for all fields which refer to the reference field, provided the field does not have its own prompt function defined.

Reference fields are commonly used by the Visual LANSA Logical Modeler to establish attribute data types or standard fields in a model. If you have used the LANSA modeling tool to create your database, your fields will probably use reference fields.

Reference field example

Reference fields are commonly used for dates. Most applications have dates: Start Date, Birth Date, Application Date, Closing Date, Delivery Date and so on. If all the dates reference a field called DATE, then the specific validations and error messages relating to the date can be copied from the DATE field. If all the dates are to be within, say, 60 days of the current date except Birth Date, then you create, for Birth Date, the specific range validations required. Should the date field change in size, such as the YY of the year to YYYY, then only the DATE field needs to be changed. (Naturally, report and screen changes resulting from such a change need to be handled in the traditional manner.)

...

Also See

...

...