I have a form that has 20 different objects that can affect 5 different totals. I don't want to copy the 5 different groups of code to every object that would affect a total. How can i put 5 different codes out and call one when needed. Please give an example. obj1 calls TotalA and TotalB, obj2 calls TotalA and TotalC. I don't know the syntax or where to put the code. THANKS
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How use 5 diff code to total in form without put on each object.
- Thread starter PBSLinda
- Start date
- Thread starter
- #3
PBSLinda,
There are several ways to do this in Paradox, each appropriate for different approaches and needs. Can you provide more details about what you're trying to accomplish and how you've laid things out so far? That will help us provide a relevant example.
I could mock something up that does what you asked, but it might not be the best approach for your current design. Are the sources fields in a table? Is the target a field in another table? What's the calculation in question? What level of detail do you need in the example? What's your experience level? What sort of tutorials are you looking for? (If you have a few moments, you might ckeck out some of the tutorials I've placed on my web site; they cover a range of techniques. The URL is
We're happy to do what we can, but my mind-reading abilities are a bit on the fritz today. (What can I say, I'm still working on my first cup of coffee.)
-- Lance
There are several ways to do this in Paradox, each appropriate for different approaches and needs. Can you provide more details about what you're trying to accomplish and how you've laid things out so far? That will help us provide a relevant example.
I could mock something up that does what you asked, but it might not be the best approach for your current design. Are the sources fields in a table? Is the target a field in another table? What's the calculation in question? What level of detail do you need in the example? What's your experience level? What sort of tutorials are you looking for? (If you have a few moments, you might ckeck out some of the tutorials I've placed on my web site; they cover a range of techniques. The URL is
We're happy to do what we can, but my mind-reading abilities are a bit on the fritz today. (What can I say, I'm still working on my first cup of coffee.)
-- Lance
- Thread starter
- #5
Lance,
This is for a metal shop program. Form QP has 3 pages, 3 main tables, QuoteMst, QuoteItem & QuoteDtl. During a Quote if a change is made to one of the 3 table fields (grade of metal, size, add a hole or cut)diff totals in the QuoteItem need updated (beg Labor, weight removed, outside labor). 1 to 5 different groups of totals could be updated depending on the field changed. Some fields then need recalculated because they are based on % of finished weight or labor charge to get final $ for quote. There are about 20 diff reg fields & 25 diff total fields within 5 groupings that can be involved because of one change. I scan the QuoteDtl (holds weight info, Lngth, Wdth, holes, cuts)to recalc weight and price changes/hole,cut,etc. Again there are fields in all 3 tables that could change the various totals. I would say that my Paradox skills are in the middle, not novice, but far from an expert. I currently have push buttons to hold the total code, but the employees can't remember to push the button. I have to have the totals update immediately upon any change. After the form updates they could put in an adjustment to change the totals again until they see what they like. I am checking the website also. Thank you for looking at this. Linda
This is for a metal shop program. Form QP has 3 pages, 3 main tables, QuoteMst, QuoteItem & QuoteDtl. During a Quote if a change is made to one of the 3 table fields (grade of metal, size, add a hole or cut)diff totals in the QuoteItem need updated (beg Labor, weight removed, outside labor). 1 to 5 different groups of totals could be updated depending on the field changed. Some fields then need recalculated because they are based on % of finished weight or labor charge to get final $ for quote. There are about 20 diff reg fields & 25 diff total fields within 5 groupings that can be involved because of one change. I scan the QuoteDtl (holds weight info, Lngth, Wdth, holes, cuts)to recalc weight and price changes/hole,cut,etc. Again there are fields in all 3 tables that could change the various totals. I would say that my Paradox skills are in the middle, not novice, but far from an expert. I currently have push buttons to hold the total code, but the employees can't remember to push the button. I have to have the totals update immediately upon any change. After the form updates they could put in an adjustment to change the totals again until they see what they like. I am checking the website also. Thank you for looking at this. Linda
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question