select/filter scenario

have a clients table has an account_Status flaghave a details table paymentsthe list view is a straight listing of the table payments – no links to clients table (except for the AccountId)on the payments list-view I need to filter out any payments where clients.account_status = 0, or display all records where clients.account_status =1 whichever way you want, but since there’s no clients reference in the query, i’m trying to figure out how to squeeze that filter statement in… ( AND clients.account_status=1)any thoughts, or will i have to create a view - if so – will it contain the edit/view/delete links to the proper record ?

or… should I just create a lookup query to the clients table and insert it into listview_row_rendering event and if account_status == 0 hit the row?thanks,

ok so I did it this way in:function ListOptions_Rendered() {
if(_getClientInfo(“account_status”, $this->Account_Id->CurrentValue)== 0)
$this->RowAttrs[“style”] = “display: none”;
}no use creating more files…

What is “_getClientInfo()” function? Is it your own global function? Have you already defined it in “Global Code” section? Please post that function code for more discussion.

yes that’s a custom global function.
i resolved my question using that function to simply lookup the value in the clients table and hide the payment record if cancelled.