Can someone tell me why this works the way it does? Or how to keep it from doing it in the "correct" way.
Say I have two items in the navigation pane in the RTC. One is called Purchase Orders, the other Purchase Orders - Received Not Invoiced. I understand that the second is a subset of the first, and so NAV tries to be logical and creates a tree like menu for these two items where you have to click and expand to show the Received Not Invoiced menu item. I just want them listed out like I have on my form (using the transformation tool).
The only way I know to get rid of it is to add a WHERE clause to fake it out. So then it doesn't think that the second is a subset of the first. Anyone else experienced this? I've attached an image.