Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Jim65

  • Rank

FileMaker Experience

  • Skill Level
  • FM Application
    14 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Windows 7 Ultimate

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. comment, Thank you very much for your help. I looked at the file and tried to understand it from the point of view of my file. I got it to work exactly like I had hoped! Thanks again, Jim
  2. The Id connects the student table to a rank table. It's true that one rank has many students so maybe I just stated it incorrectly. In the Rank table is what's called kyu and dan ranks. These correspond to colors. Many of the colors have sub ranks but only one color that's why I was searching by color. My script goes to the students table, finds all of the Active students then looks for a color that I entered into the 'EmailFind' field. It then 'Finds' those students. It works fine if I only search for one color or all but not for just 2 or 3 colors. Sorry, I'm gonna be late! T
  3. Students::StudentsIdPk to Ranks::StudentIdFk I currently have the search field (EmailFind) on my Main Menu layout. It is a txt field set to global storage. I'm thinking the checkbox would work but I'll be darned if I can figure it out. I don't like to make excuses but I am getting old! I have to go teach class right now and won't be back until after 8 EDT tonight. I apologize. Thanks, Jim
  4. The example certainly does find whatever I check but I'm lost as to how to implement it into my file. Instead of entering the list of states I need to find my already existing ranks? I truly have no clue? I also wondered why I could download the file from you but not on my own. The links are different: https://fmforums.com/applications/core/interface/file/attachment.php?id=24674 - the link you sent me. http://fmforums.com/applications/core/interface/file/attachment.php?id=24674 - the link in the article. It's missing the s on the end of http Thanks for your help but I'm goi
  5. Thanks, I'll check it out. When I click the link in the article it doesn't do anything. But yours worked. Much appreciated.
  6. I look at that thread but couldn't download the file?
  7. No. I want to find students that have a black belt AND other students that have an orange belt or all the brown belts, all the purple belts and all the green belts. Then send this found set an email. The RankColor is: Black Brown Purple Green Orange Yellow White Occasionally I have to send out emails to only one group of them or several. Everyone except a white belt will have earned the other belts up to black. But each student only has one current belt color.
  8. comment, I don't have the belt colors in EmailFind. That is a search field I use to find students to send emails to. I need to find everyone that has a, say black belt and the ones that have maybe an orange belt not either but both. Or yellow and brown or black and purple and yellow and so on. The script I have is: If isempty (students:EmailFind) Beep Show Custom Dialog - Warning goes here Go to field Students::EmailFind Halt script End If Got to layout - students layout set error capture on Enter find mode set field students::RankColor ;
  9. Hi! Thanks for taking the time to try and help me. I have a script that uses a field named EmailFind. If I enter a karate belt color such as Black it finds all of the students that have a black belt and I can then send them an email. That works fine. However, if I wanted to find, say, all of the black belts and yellow belts I type in black...yellow and it finds every belt starting with a b through a y. I understand this is how Filemaker searches. Is there a way I can pick 1, 2 or more colors (the names for the colors) and only find those? Any help is greatly appreciated. Jim
  10. Steve, Thank you for your time and input. Without actually showing me where the issue is with the way I'm doing things it's difficult to learn to do better. I can't hire someone - that's why I'm asking the forum for help. This 'version' of my file is of one that started with Filemaker 8 so it's come a long way also. I'm sure there's ways to do things better and I do try when I'm shown. This old dog can learn new tricks when taught! That said I'd like to mark this as closed as I've figured out what was wrong with what I had already set up and have gotten it to work exactly like I want
  11. Lee, I am attaching a copy of my file. To create a record for the payment of dues and such you need to go to the Students Information layout and click the Payments tab. Click the New Payment button and click on what was paid - Dues, Clinic, Exam or ISKF. Then go back to the Main Menu and click on Print Attendance. This the layout I want that information to show. To change the Month and year of this layout you need to go to the Administration Menu and click on the Month and Year drop downs where it says Select - Month/Year. This runs a script that updates the information and takes you back
  12. Long winded but hopefully descriptive enough to describe my problem. I have the following Tables: Students Ledger Ledger_Chgs Ledger_Pay Ledger_Self They are connected as such Students table to Ledger table - StudentIdPk > StudentIdFk Students table to Ledger_Chgs table - StudentIdChgs > StudentIdChgs Students table to Ledger_Pay table - StudentIdPay > StudentIdPay Ledger_Self table to Ledger_Chgs table - StudentIdFk > StudentIdFk These are all used with a layout called Students. In my students layout I have a portal to Ledger_Pay (and Ledger_C
  • Create New...

Important Information

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