Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
180
Parent/Child tables in Dataset - an easy one I suspect
posted

I am using code very similar to the example in the article entitled "Binding to a Hierarchical SQL Database". My parent fields are KeyPrefix,ObjTypeDescr,aTypeID my Child Fields are ObjKey,ObjName,bTypeID.

In FieldLayoutInitialized I set the Visibility of the "aTypeID' column to false. I want to do the same with bTypeID. When I check the fields as below

MsgBox(e.FieldLayout.Fields(3).Name)

I see my fourth "field" is "Hierarchy" and I do not see the fifth and sixth fields. I would be obliged if someone could post some sample code so that I could understand how I can interogate my fourth field object to discern the actual column names for the purpose of setting their visibility to false.

Thanks

Parents Reply Children
No Data