Parent & Child Table key fields

In the gint std us files, the Library, data template and subsequent project database files;

I understand that the Soil Components tab is a child of the Lithology tab, and

that the PointID and Depth are the key fields for the Lithology tab and that those fields are subsequently the key fields for the Soil Components tab.

What I don't understand is why is the Soil Components tab also pulling the Bottom depth value from the Lithogoly tab as well the Depth?

The Bottom value is not a key field and I am not seeing where the Soil Components tab is being told to pull this value from the parent table.

Thanks,

Brian L.

Parents
  • Hi Brian,

    In the "Lithology" table the "bottom" field has a property checked that says "show in children" . This is why it shows. goto lithology .. put your cursor in the bottom field. right click and goto field properties . You will see show in children is checked. Uncheck it if you do not want to see it in child tables of the lithology table. You can also access the property by opening the database in Data Design.

    Answer Verified By: Brian L. 

Reply
  • Hi Brian,

    In the "Lithology" table the "bottom" field has a property checked that says "show in children" . This is why it shows. goto lithology .. put your cursor in the bottom field. right click and goto field properties . You will see show in children is checked. Uncheck it if you do not want to see it in child tables of the lithology table. You can also access the property by opening the database in Data Design.

    Answer Verified By: Brian L. 

Children