many to many relations

[caveat1]

Needing a formula or a join table, or?

In an anchor-buoy table occurance scheme, I have job specs (some y/n, some multiple choice)in one table, service IDs and rates in another. (pt is to be able to change rates w/o changing formulas throughout). Got a nice calculation to relate job to svc ID. But I need a formula that says "if the svc ID from this job field matches this Svc ID in the rates table, use that rate." Getting a portal to do this has me flummoxed. Hints toward the right direction greatly appreciated!

[MarkWilson]

Try a lookup or an auto-enterd calculation with the Lookup function.

[Phillip Holmes]

Hi

Are the tables related at the moment.

If so you do not need to change anything as the relationship should point the calc to the correct figure everytime

EG: (Table1::Myrate*Table1::Hours)-Table2::ClientDiscount