Sergey:
I was wondering if there was a way to connect the security to the drop down list - -which is cool by the way - - in the advance search. In other words, when someone logs on to the site, I have the first page set to show zero records. Then, they choose advance search and the drop down list shows the cost centers that they are responsible for. Now it shows all of the cost centers, even though I have advanced security set to "users see and edit own records only".
I was hoping the where clause would work, in the advance search option. As in, where security level (security table) equals cost center (main table).
Thanks in advance for any help.
David
