Calculation of Values Through Mulitple Forms
Hi i have been banging my head over and over again for the last few days and i seem not to be getting anywhere, apart from building forms and hiding specific fields in deluge scripting thats as far as i have got. I have read that this is supposed to be easy and everytime i try to create an application i'm hitting the same wall and keep wanting to go elsewhere to create applications. I get replies for my posts saying if i need help then follow links to professional developers! hold on a minute if it's that easy to use why are potential customers being forced into paying additional costs to have developer complete applications for us.
It's not as if i'm trying to ask too much from my question, i suppose once one person explains to me how the syntax works in an example then i can probably understand it much easier and progress with the project on my own, your help would be appreciated.
I'm trying to create a calculation based app and will require many calculations across many fields ensuring customer balances are kept updated when either forms are submitted and updated.
in this request i have 3 forms:
Form Title: Bank Accounts / Form Link Name: Bank_Accounts
Form Title: Book Maker / Form Link Name: Book_Maker
Form Title: Single Bet / Form Link Name: Single_Bet
Single Bet Form - has a look up field that links to Book Maker Form allowing a selection of book makers inputted by the user.
Book Makers Form has a look up filed that links to Bank Accounts Form allowing a selection of banks inputted by the user.
What i'm trying to achieve is by calculating a current balance field in the bank accounts form with current balance field in the book maker form by a back stake field in the single bet form and save them in a total running balance somehow.
current balance + current balance - back stake
Once this calculation is complete and shows a running balance i can then move on and learn how to calculate depositing funds into bank accounts and Book makers then also withdrawing funds from both bank accounts and Book makers leaving the total field showing a true reflection of total balance when transactions take place.
Thanks in advance Chris