• gINT - using <<#>> and referencing previously listed values

    I am creating a new User System Data function that will report what soil visual classification is for each sample listed on the output report. I have run into a problem since the USCS table only defines the unit based on the top depth rather than the…
  • Field's lookup properties based on a field from a parent table.

    I would like to have a field's lookup properties based on a field from a parent table. I have 2 tables [GEOL] and [GORA]. [GORA] is a child table of [GEOL]. [GEOL].has a field for the rock type [GEOL].[GEOL_Origin] (e.g. Sedimentary, Igneous, Metamorphic…
  • Re: Lookup definition missing in current library

    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…
  • Re: Average of Recovery lengths

    The following provides a solution to the original post question. There are other approaches that may work as well or better. Specifically, you should check out the following alternate solutions: Determining average recovery using SQL commands posted…
  • Output Graphs: Repeating Text

    I am trying to make a table for Plastic Limit. I am wanting to show all the inputs from Attb Readings that go into calculating the Plastic Limit. Since the data is the last two entries in Attb Readings, I am trying to use a DataSetKey to pull up from…
  • Lookup definition missing in current library

    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…
  • Formatting a fixed curve on graph (colour, type, fill) with an expression

    Hi all, I'm trying to add various granular specification envelopes to a grain size graph. However, I now want to see multiple specs on one graph, and I need them to have a different colour/fill. Here's my workflow: - user specifies granular specs in…