Portal does not show anything
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:
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