Hi- I am looking to restrict the number of entries in a lookup field in my form and need to specify the deluge criteria. I'm stuck!
I currently have two fields I want to restrict with the return of records: "status" field and "discharge_date" field. I want the criteria to return only records that are either "active" status or have a discharge date within seven days of the current date.
Can someone help me with the correct criteria to use?
Thanks,
Troy