AnsweredAssumed Answered

calcs using unrelated tables

Question asked by symbister on Feb 24, 2011
Latest reply on Mar 8, 2011 by symbister


calcs using unrelated tables


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...