Hi,
Is there a quick way to list all the fields in a data template that are not correctly pointing to a lookup from the library?
i.e. The fields display "[LOOKUP DEFINITION MISSING IN CURRENT LIBRARY]" down the bottom of the screen when you select the field, but I am hoping not to have to trawl through all the fields if there is a better way.
Thanks
Calan.
Calan, this notification currently appears only in the INPUT interface, in that information zone at the bottom of the screen. It appears only when the cursor is in the field with the missing lookup definition.
Working in DATA DESIGN>Project Database with the Current Project (or current Data Template) selected may provide a faster way to verify the presence of lookup lists. With the data structure open, you can arrow or click down through the list of fields for each table and view the Lookup property for each, then compare it to the list of available lookups.
This will be even easier if you have a list of the Library Tables, Lookup Lists and Readings Lists in the library:
Hi Calan
The Datgel Administrator Tools - Lookup List Check Tool is designed to do just that, see www.datgel.com/DatgelAdministratorTools.aspx
We have just released version 2, which support SQL Server and a number other improvements.
A trial is on our website, fully functional for 14 days.
Cheers
Phil
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.