AnsweredAssumed Answered

Portal does not show anything

Question asked by Emmanuel on Oct 17, 2012
Latest reply on Oct 19, 2012 by philmodjunk

Title

Portal does not show anything

Post

     I understand how portals work. Yet, I am unable to get that one working, it does not show anything like if there would be no link at all).

     I started from FM12 Invoices starter solution and added a table called "fiscal year". In that one, I have "year match field" which are about 15 records: "2001-2002", "2002-2003" ... "2011-2012" in text format. It is linked to invoice table through "fiscal year" field which is calculated (text result) as followed:

     Case (

     Fiscalyear start date < "Invoice Date" < Fiscalyear end date; "2001-2002";

     Fiscalyear start date < "Invoice Date" < Fiscalyear end date; "2002-2003"; .....)

      

     That part works since I do have the results. However, it does not want to connect to "fiscal year" table. What is wrong ??? It must be some details that are I don't get  

Outcomes