Asuncion LB

Hi, Attached is how the database looks. I tried uploading the database but it won't let me. I am utterly confused.... fmhelp.bmp

Hi, Thanks for responding.... Sorry I am really new with Filemaker. I have all my records in a portal. I am almost there but it is only adding one portal row. I currently have a field called FY 710000_710004_2Spent_Calculation with calculation If ( ${710000 Equipment Major}::Account No. = "710004" ; ${710000 Equipment Major}::Budget ) Then a summary field called FY 710000_710004_3Spent_Summary with Total of selecting the field above.... Right now it's able to find only one 710004 in my portal, but I have three 710004.... How do I make it so it finds all 710004 and add the total? Thanks..

Hi, I am new to FM.... I need help with a simple calculation I have two fields one is called Account Number (will have accounts like 710004, 711000, 711002, etc.) and another field called Total (this field will hold how much an item is say a computer for $700). I have created this in a portal and I am able to sum up the Total field. I would like to know what is the calculation to get: If Account Number is 710004 then add all Total Fields that have Account Number as 710004. Does this make sense? I am just trying to find a fast way where I don't have to add up all the fields that are say 710004 manually. Thank you soo much for any help :)

Hello, I am new to Filemaker and this might be a stupid question and I am sorry if it has been asked before, but I googled and googled and cannot find an answer. My question is how can you separate the layout popup-menu so that when you click on the layout popup-menu instead of scrolling up and down and up down due to the tremendous forms is there a way to divide the layout popup-menu into two columns or more. It would be a great help if it can be done because time would not be wasted on something so trivial as scrolling all the way down to get to the last form. Any tips would be great!