gene.seeker

Is there any way to divide a subsummary by a grandsummary when the breakfield is not local (e.g. in the table on which the layout is based)? For example I have a report with academic years across the top and student majors in the left column. The subsummary is sorted by STUDENTS::majors. The summary fields int his part on the layout are s_yeari which is a summary based on c_yeari, which scores "1" when i="year". The layout has a grand summary part with these fields also. This is all working fine and is returning correct numbers, but I'd like to calculate percentages, but GetSummary seems to be not working when I try this, and I'm starting to think that it's because my breakfield is not stored in the table on which the layout is based. (GetSummary works when I use a field in the table, so the syntax is correct.) Is there a way to make this work or should I switch this all around so the layout is based on the students table, which contains the breakfield?

I have a table with STUDENTS and I want to set up relationships between some of them. We have a mentoring program and in any particular academic year some students (upperclassmen) will be "Mentors" for new majors "Mentees". There will be new Mentor-Mentee pairs in successive academic years. I want to keep track of this. So, I want a unique identifier for a Mentor-Mentee relationship and I want to keep track of who's the mentor and who's the mentee in each relationship. So it seems like I need a "Mentor-Mentee" Table that has a unique record key, but I'm not sure what kind of foreign key to use to link students in. Should I have a mentor_fk and a mentee_fk, and should each of these link to the unique key for each student. Can I link twice to a student from this table? Or is there a better way to set this up?

I did figure that out and now it looks great. Thank you.

Yes, that appears to work! Now I have to run searches in the JOIN table, which will ultimately not be a problem, but it's not so intuitive to setup because all the JOIN layout shows is the foreign key for the course, not the course name. And coursename isn't even a field in the JOIN table. Eventually this will all be scripted but right now is there an easier way to lookup the coursename in the COURSE table that the foreign key in the JOIN table. Seems like I need another portal in each JOIN record??

I want to keep track of student enrollment in courses. I have three tables: STUDENT, JOIN, and COURSES. I have a portal in a STUDENT layout so I can see what they've taken. I want to eventually do statistics on the student enrollments to determine when they take certain courses. Currently lines 1-7 of the portal contain Fall Freshmen courses, lines 8-14 contain Spring Freshmen courses, etc. The find function lets me find students who have taken certain courses (say, Chemistry). But the find returns ALL records where any of the portal rows contain Chemistry. What I want to know is whether portal rows 1-7 or 8-14 contain a Chemistry entry. Can I do finds for specific portal rows? OR Should I change my setup and include a new table called ENROLLMENTS. Enrollments will be between STUDENTs and JOIN, and then each student will have 8 enrollment tables (one for each semester). THEN I create a layout showing STUDENT records listing all enrollments. And if this is the case, I could probably have 8 portals on the student record (one for each semester). This way I can search for specific enrollments. Hope this is making sense. If you are used to the business setup, STUDENTs corresponds to CUSTOMERS; ENROLLMENTS corresponds to INVOICES, JOIN is LINES and COURSES is PRODUCTS. Any advice from more experienced programmers would be much appreciated.

I should add that I've tried the following 1. Insert Text ["Mytext"] 2. The same with a carriage return after the text 3. Set Field [sTUDENTS::cleanout] where the cleanout field contains an entry I set.

I think I have a related problem with my script. It selects the correct row and field in my portal and also selects the correct item in the value list, but then it hangs. If I manually click or hit return then the portal field can be populated, but I really want to have a script that automatically prepopulates the values in the portal with defined values. To provide more information: This is a database to keep track of students and their enrollment in courses. I have the following tables: STUDENTS, JOIN and COURSES. The portal is on a STUDENTS layout. The first column of the portal is a value list that gets a list of courses via the JOIN table. The value list contains unique values coming from the key field in JOIN passed from COURSES. The remaining columns just populate the related information (coursename, coursenum, credits). This all works fine manually, but I've noticed that I have to populate the portal rows sequentially, and sometimes I don't want to do that. So, what I want to do is to pre-populate the portal entries using generic enrollments and then I'll go back and edit. Is there a way to get a script to do this?

Can you post how you pass the contents of the global field into the find command. I can set the global field to have the contents I want, but I can't figure out how to get the find command to search for the contents of the global field. Thanks, -Karen F.

I want to concatenate several value lists, called produce, baking, dairy, etc, into one large list called grocerylist. Is this possible? If so, how? I've already tried to concatenate the fields and that doesn't appear to work.

The simplified scenario: a layout with fields: item, brand, price, unitprice. I would like to write a script whose purpose is to find other records that match the currentitem and then to display only the item, store and unit price on another layout. I want this find to be executed with a button on my original table, so I want the script to know what the active field contents for item are. I am new to filemaker and am going nuts trying to do this very simple thing. How do I pass the active field contents for item into the find function within a script and return the find set???