In the Soil/Rock description area in my log, I need to combine information from three sources so that text gets appropriately stacked and pushed down and so that stratigraphy lines are drawn appropriately.
- I am pulling each sample soil description from the SAMPLE_DESC table through a Component Library Table named DESCRIPTION SOIL LITHOLOGY - I have tested it and it is working
- I am pulling each rock run description from the ROCK_RUNS_DESC table through a Component Library Table named DESCRIPTION ROCK LITHOLOGY - I have tested it and it is working
- The above are specific to each sample. The lithology break lines are coming from the STRATIGRAPHY table which is not sample based, but just a PointID, Depth table. These breaks may come after multiple samples, depending on how things are grouped.
I am trying to combine the above in a COLUMN-TEXT VS DEPTH PROPERTY entity on my log. How do I combine these three items so that the three items don't overprint each other? I've lost count of the different things I have tried to make this work.
Thank you for your assistance.
In your COLUMN-TEXT VS DEPTH, could you write your text expression where if there's data in the first table, display that data. If there's data in the second table, display that data. If there's data in the 3rd table, display that data?
<<HasData(Text 1, Text 1)>> <<HasData(Text 2, Text 2)>> <<HasData(Text 3, Text 3)>>
That didn't work Paul, but I did some more trial and error. What ended up working was just combining all of the soil and rock data into one component table rather than doing two. Given that the SAMPLE_DESC table and ROCK_RUNS_DESC table were both child tables of the SAMPLE table, I just used the <<SAMPLE.Depth>> as my depth field.