I have table A,B,C in my Framework model and i am pulling Max date from table A by writing filter max(retrieve date) ,this would pull this to table B the latest date but i want all dates in table C. I have relationship 1:1 to 1:n relationships.How to achieve this requirement.Please Help.Thanks
What relationships exist between the three tables? What item or items are the relationships based on? I'm afraid you haven't provided enough information to allow anyone to help. Can you be a little more specific?
Regards,
MF.