misstmitchell

Hi Kurt Thanks! I works a treat - I've changed the fields to global and everything seems fine Thank you so much! Tamsen

Hi there I'm new to filemaker, and I'm running into a really frustating problem that I'm hoping a guru out there can help me with. Here is the set up. I have a basic database designed for entering, sorting and summarising bugs in a piece of software. All is going well except for a "statistics / summary" page. What I want is a page that summarizes the number of bugs of different states, and different severities displayed in a table like (and this is a simplified version):- Total A B C D < these are severity categories All bugs 25 2 17 2 4 Open etc Open please verify fixed Closed fixed Closed by design Currently, the way I have it set up is a different number field for each of the numbers I want to calculate above, and I've begun writing a script that performs a find on the bugs entered which satisfy the specific criteria, and counts the result. The first one is easy - find total # of bugs - just a script saying show all records insert calculated result [select, "All bug # totals", "Status (CurrentFoundCount)"] Got to Layout ["Statistics"] For testing purposes, and to get my head round this, I've been writing many little scripts for each search / find, and creating a script that performs the seperate subscripts for each find / count procedure. So moving along, the next mini script is to find the total number of A severity bugs:- perform find [restore, replace found set] insert calculated result [select, "All bugs #A", "Status (currentfoundcount)"] got to layout ("Statistics") the same kind of script is written for all the remaining fields, just with differing find criteria based on 2 fields, "bug status" (open, closed etc.) and "bug severity" ("A - must fix" to "D - enhancement request"). If you perform the sub scritps individually, they work, and return the numbers in the correct fields. If you try running the main script which calls these subscripts - which I want to then add all the counts for all the finds, the 1st # is shown (i.e. for total number - with no find scritp step) and the last find script number is displayed. However all the other number fields are blank. I'm assuming this is either a bug or a misunderstanding of the status(currentfoundcount) functionality on my part. It seems that status(currentfoundcount) clears each time, and only returns the last count from the subscripts in the main script. But it's driving me insane and I need help figuring it out! TIA Tamsen