I need to filter a lookup filed in a Calendar list. I cannot use InfoPath and so I'm using SharePoint Designer.  Basically, I need my lookup field to display all active clients. Any assistance would be so greatly appreciated.