9 Replies Latest reply on Jul 18, 2013 1:25 PM by pantarhei

    Can a relationship fail for internal reasons?

    pantarhei

      I am, somewhat unwillingly, working on a very idiosyncratic timesheet and billing system for a small consultancy firm. The scope, as I expected, grows by the day.

       

      Until yesterday I managed to fulfil the client’s requests, mostly even exceeded the initial idea, but then something went wrong.

       

      I have a portal in Billing showing unbilled hours for the Project in question, works fine. Now we need another portal showing Travel expense accounts in a similar fashion, but it shows nothing. I created a Test table and in that a portal works. In both cases the relationship is Project number to Project number, verified several times.

       

      Is it possible that this is an internal problem? I could use the working Test table as a basis for a replacement Billing table, but at this stage it is not a quick thing to do, albeit technically simple. But would that fail at some point too?

       

      (I so wish there’d be a simple way to change the source table for all selected fields in a layout! Maybe there is?)

       

      We are using FMP 11.