AnsweredAssumed Answered

Need Help with Simple Calculator!

Question asked by MacMcAhren on Sep 19, 2012
Latest reply on Sep 20, 2012 by philmodjunk


Need Help with Simple Calculator!


     Project = Rate Calculator

     Filemaker Experience = Total Newbie


     I am attempting to create a simple rate calculator. This would be pushed to Filemaker Go for use on iPads and iPhones in the feild.

     Calculator would take into account 11 different rate values. I have created a Rate Master database with the feilds "Rates" "Amount" and "Travel" and populated the feilds.

     I have created a "Rate Calculator" database. This is where the problems begin.........

     I need the calculator to visualy display the following

     "Rates" - This should be a pull down list, that displays the "Rates" from "Rate Master" database

     "Hours" - This should be a user input value.

     "Hourly Total" - This should be a calculation of the "Amount" that corresponds to the "Rates" chosen above * the "Hours" above.



     "Travel Fee" - this should be a radio button or pull down with the choice of "Yes" or "No"

     "Travel Amount" - this should display a $0 if pull down above is chosen "No" or it should pull the "Travel" record from the corresponding "Rates" chosen above from the "Rate Master" database.


     "Total" - should be a calculation of the "Hourly Total" + "Travel Amount" 


     I have done a simple layout of the "Rate Calculator" ... I have attempted to do the relationships of the database. I have told it to pulls from the corresponding feilds or databases.

     I cannot get it to work.

     Everytime I try to use it, I get  "No records are present. ....." error. If I create a blank record in the calculator (Which I do not need it to make records, I just need it to do simple calculations. I do not want it to record the calculations) then the pulls downs do not work, and it fails to do any calculations.

     Can someone HELP PLEASE??!! What am I missing?? 

     As I said earlier, I am a total newbie, so I know it s probably something simple, but I probably wont understand your explanation of "check the relational links between the databases and put in a if (asdasd::asdasd) command. Please try to make it understandable by a first time Filemaker user. I would even be willing to pay someone to finish the work/links or whatever it takes to get the darn thing to work!!