8 Replies Latest reply on Mar 8, 2011 6:41 PM by symbister

    calcs using unrelated tables

    symbister

      Title

      calcs using unrelated tables

      Post

      OK, I'm sure this has been done before - and I have searched for it across both FMP help and this forum..

      using FMP11 on Mac OS 10.6

      I'm trying to set up a quote system, where the pay rates are in one table, and are used in calculations in an unrelated table.

      Ideally what I'm hoping to have is a table with a single record with the rates able to be updated as needed, and a table with events that users can enter staff requirements and it calculates totals.

      There's no 'link field' between the two tables that would make any sense, but I keep getting errors when formulae are referencing non-related table.

      Many of you have been helpful in the past - so please any help would be gratefully received...