jmattw24

Can Anyone help me??

I am still not sure what exactly to do. I understand all reports should come out of the referral file, but how do I build one or some of these reports. Are there fields I need to add to my file? Calculations? I am just uncertain where to start. Thanks-Any Help is appreciated. I am not making a dime off of this.

Ok guys another dumb novice question...As I said before I am working on a db that tracks discipline for a School principal. I need to develop several reports but do not know how. My files: student,teacher,rules,punishment,referrals. The reports that I need help with are ones derived from the file referrals which contain the following fields:Referral ID,Date,Time,Student ID,Teacher ID,Punishment ID,Primary Rule,Secondary rule,Incident Description,Punish start date,Punish end date,Return Date,Punish Days,Current Date. The reports I need to generate are of the following:# of referrals by teacher, # of referrals by student, # of referrals in day,week,month and average, top rules broken, list of referrals by each student. BTW a referral is when a teacher/bus driver refers the student to the office for punishment. Where do I start?

Thanks Guys. I worked it out but did it a little different. The main problem I had was that "001" was not the true value, but "1" was really the value. After I got rid of the zeros it worked. Now I will have to make another post because I need to do some reports which probably entail some calculations...I getting better at all of this!

Hello All! I am working a db application that tracks conduct/discipline for a school principal. I need to set up a script to print a certain layout dependent upon a text value in a particular field. For example:In the current record IF the Field Punishment_ID = "001" then go to layout "ISR Letter" and print 3 copies using the current record IF the Field Punishment_ID = "003" then goto layout "Suspension Letter" and print 3 copies using the current record...I am new to this so I am not sure what the procedure to do this would be. Thanks [ November 14, 2001: Message edited by: Matt Johnson ]

Sorry, but how do I create this script. Is this AppleScript or VB or what? Using Scriptmaker inside Filemaker-I don't see how or where to do this. Do I need to just do this in a text file and Import it or what? Sorry to be dumb I have just never done this.

Thanks for replying! Just to let you know. I tried the scripting with a little success but not complete success. I could not get the file to open to a certain layout. For instance you are on the Referral file, a student walks in- you don't he is not in the database of students because he is new. So I have button Enter new student. The button needs to take me to the student file (which is probably already open because when you open referral they all open)and to the student entry layout. I could get it to open the file but not to go to a certain layout. Now you have to get back to referral from the student file so you need a button to do the same thing. As far as using the value lists I am doing this with the teacher,punishment but the only way the value list will come up is if you put in a ID which no one will ever be able to remember for every item. ARGHH this is frustrating! I could send you the files so you could see the mess for yourself.

Hello All! I am in a mess! I have volunteered to help a school principal friend of mine develop a relational database to track school discipline. I think I have a good grasp on the fundamentals but am not sure. I have created 5 files (students,teachers,rules,punishment, and referral) Obviously the student and teacher file holds all the student/teacher demographics as well as the rules hold the rule_id, rule_name, Rule_descript. The referral table/file is what I would call the main/master file (where most of the action takes place). It is where the principal will record a "referral" from a teacher that a student has broken a rule. I have linked the tables/files by student_id, rule_id, teacher_id, Punishment_id. This is where the confusion comes in...I create a layout to enter the referral, but the only way you can get the student info to come up automatically is if you know the student id as well as with the teacher_id, punishment_id, rule_id etc. how can i set this up so that I am following db theory in keeping apples in one file and oranges in another? Also how could I set it up so that there is a layout in the referral file that allows you to enter a new student into the student table as well as with the teacher, rule, punishment without leaving that referral file. Maybe this isn't the right forum to ask but I was unsure of the subject. it is probably very simple in your minds, but only working with the product for 2 days has me a little frazzled. Let me know if anyone has any suggestions..Thanks!!!