How to filter records before displaying on Layout.
I have two tables X and Y.
I have columns x1,x2,x3,x4 in table X.
Columns x1,y1,y2,y3,y4 in table Y. (Field y1 can take either "yes" or "no").
Note: x1 is common field for both the tables.
Now the layout i have is A which takes the column values from table X i.e, x1,x3 and x4
Problem: I need to filter the layout A before it displays. Filter is, i need to check in table Y whether for x1 the value of y1 in table Y is set to "yes" or "no", if it is set to "yes" only then i need to display it in the layout A.
Someone please suggest me how to do this?
Please let me know in case you require any additional information.