caveat1 Posted August 4, 2007 Share Posted August 4, 2007 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! Link to comment Share on other sites More sharing options...
MarkWilson Posted August 5, 2007 Share Posted August 5, 2007 Try a lookup or an auto-enterd calculation with the Lookup function. Link to comment Share on other sites More sharing options...
Phillip Holmes Posted August 11, 2007 Share Posted August 11, 2007 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6266 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now