Month Filtering in Filemaker
Posted on 2011-09-16
I have a HR database built for our school. Each month our teachers are billed for a certain number of utilities since a number of our teachers live on campus. I have set up separate tables for Electricity, Phone, Postage, Vehicle, Facility, and Other Charges. I also have a table for Staff and another for Salary and Other benefits. The person who set this up also put a School Year filter in so a drop down changes all information from year to year. It works really slick.
Now for my question. I want to create a layout that pulls in teachers monthly utility charges each month which allows them to see only that months bills. Each of the utility tables has the School Year field and a Month field. The school year works great as I said, but I can't figure out how to filter so a drop down will display the utility sheet for staff to bring up only the records entered based on the Month. So in the Electricity table I have amounts for Aug and September, but the portal it is displaying records from the table so when I change the month it also changes the month back in the layout where the record was created.
this is driving me crazy. Please advise.