Set Filters for dependent lookup fields
I have a form that contains two lookup dropdowns from two other forms. I need to populate the second lookup based on two fields shared by the the first lookup. I used the SET FILTERS dialog to generate ((((LGA==input.Ward1.LGA)&&(RA==input.Ward1.UID)))). However, the second lookup does not populate at all and only the first part LGA==input.Ward1.LGA gets persisted. Please assist. Thanks.