I need help for the hierarchy function, when i implemented a hierarchy statement in my code, I wanted to use the hierachy fields resulting from that statement,
(field1,field2,....). since the hierarchy statement is in Table1, i created table2 that contains field1, field2..etc. but when I debug it sends an error telling me that the fields field1, field2. do not exist.