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,