Lookup Tab

• ID Field
• Code Field
• Description Field
• Code Class
• Code Length
• No Description
• Description Class
• Description Length
• Read Only
• Default Value Sql
• Form To Lookup
• Javascript
• Stop Blanks
• Stop Duplicate
• Update Other Fields
• Table Field Name
• Page Field Name

The Lookup Object is useful when you require the User to be able to select a record from another table.
When the User double clicks on the Code field of the Lookup Object, they are then taken to a Search Screen.
When they have made their selection, both the Code and Description fields are updated with information from the record they selected.

If the User types in a value that matches the Code Field in the table the Description Field will be automatically updated.

ID Field

This is the primary key of the table you are looking up.
e.g. customer_id for the customer table

Code Field

This is the field from the table you are looking up, that you want to populate the Code of the Lookup Object.

Description Field

This is the field from the table you are looking up, that you want to populate the Description of the Lookup Object.

Code Class

This option allows you to refer to a custom style to make the field look different to the standard default.
For more information please refer to Section 7.0.1 Styles

Code Length

This sets the width of the Code field in the lookup

No Description

Option Yes/No. This option sets the visibility of the Description Field.

Description Class

This option allows you to refer to a custom style to make the field look different to the standard default.
For more information please refer to Section 7.0.1 Styles

Description Length

This sets the width of the Description field in the Lookup.

Read Only

Option Yes/No. This option determines whether the Lookup will be non-editable.

Default Value Sql

The SQL statement that selects the Default value when the Lookup is displayed. i.e. SELECT ‘1’

Form To Lookup

This points to the Search Screen that the Lookup Object will launch when the Code field is double clicked.

Javascript

This area is where you would type custom Javascript that is launched after the Lookup Object is populated.
(To refer to a javascript function that has been put on the current Edit Screen, prefix the function with nuScreen. Eg. nuScreen.totalSubform();

Stop Blanks

This stops the User from leaving the Lookup Object Blank.

Stop Duplicate

This stops the User from selecting a record that has already been saved in the database.

Update Other Fields

This option allows you to fill other fields on a Form with the Lookup Object, from the table the User is looking up.
There are two field names that need to be assigned for the update to work, they are :

Table Field Name

The name of the field in the table that is being looked up.

Page Field Name

The name of the field on the Form that you want the data from the table field to fill.

---