AnsweredAssumed Answered

How to filter records before displaying on Layout.

Question asked by shashikanthkuntla on Jan 6, 2012
Latest reply on Jan 9, 2012 by shashikanthkuntla

Title

How to filter records before displaying on Layout.

Post

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.

Outcomes