Jump to content

Marinos Kangas

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Marinos Kangas

  • Rank
  • Birthday 03/18/1979

Profile Information

  • Title
    AMOS and Communications Support Officer
  • Industry
  • Gender
  • Location

Contact Methods

  • Skype
  1. Well...silly me, I confused myself for the wrong reasons. Wim, the Sum calculation worked like a charm in the AmountAllocated field due to the relationship I have created. The ExecuteSQL looks like a godsend command I will investigate. I am sure it will come handy when the going gets tough Thank you both for your insight. Sometimes the solution is right in front of your nose, you just can't see it.
  2. Yes Wim, those are all connected to the main Invoice page and the only common link is the Invoice number. As for the Budget Code tables, at first I thought of not linking them and calculating them via script but I cannot figure out a command that will give me the flexibility of an SQL query.
  3. Hello, I am new to FileMaker and still trying to find my way around the scripting language. Even though the scripting language is quite rich, I don't feel as comfortable and flexible as I do in lets say VB. To my query now; I have designed a solution for my company which processes invoices. These invoice forms input numerical amounts tied on budget codes for each department and in turn are stored in a different table. As you can see on the image attached, I cannot find a calculation function that will sum all the amounts for each BudgetCode into AmountAllocated. AmountAssigned is the yearly department budget predefined. I will be grateful for any suggestions or ideas. Thanks
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.