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