You must have administrator rights to access this feature.
This feature may not be available in every package. Not sure if you have this feature or you want to learn more about it? Send us a message at firstname.lastname@example.org.
To share text data from one recordset to another, create a lookup field. Lookup fields allow you to use data that is stored in a library from anywhere in the Cartegraph system. Lookup fields can only be created for text field types.
When you display a value for a lookup field, you may also want to display other information from the lookup recordset with the field.
For example, the County's library is needed as a lookup from Materials.
Additionally, you want the following fields from the County's library to display on the Material detail view:
- Hazardous Materials Contact Name
- Hazardous Materials Phone Number
- Hazardous Materials After Hours Number
In Structure Manager, you can add a lookup to County on the Materials recordset. In Layout Manager, you add County to the detail view, along with hazardous materials contact name and both phone numbers from the library.
Hazardous Materials Contact Name, Phone Number, and After Hours Number are visible as read-only fields when displayed on the Materials detail view.