Conditional Value Lists - Search Screen
I don't believe this is the same issue as the recent post(s) on conditional lists. My question is how to create a CL based on one table only. That is I have a table with 25000 records comprised of 100 or so Customers and each ofthose customers has anywhere from 1 to 30 projects in the table...and there may be 100 units against each project. Large table but that's how it's available in the database I'm using.
Is it possible to construct a CL using only one table and table occurance(s) to mimic a relation to itself? I've looked for examples but only see where another table is used to create a more traditional relationship and eventually the CL.