Arcanoi

Okay, I can't seem to get it to work right, I first need a list that is dynamic that I can have that lists all given classes plus a blank space, when the user selects a class I need a find to be performed that matches the course (one field one of two possible repetitions)of the student record to the selected course in the pop up menu, it doesn't seem to work at all... what am I doing wrong? any advice would be apreciated. I need the scaleable class list because the Classes are in a diffrent table and entered seprately that way you can delete all of the students or export them as a backup and start with a clean slate of students but have a list of avaliable classes for the next year as this rarely changes

Danke Much

I checked out the attachments but I need a list view of all of the students that is completely printable and scaleable, IE if there are 200 students then there would be 20 students on a page with ten pages etc. Portals do not seem to behave the way I need them to to do this.

Okay,I have a database for summerschool registration that I'm working on, I need a report to generate a list of students for any class that has been entered into the "Class" table so that if you would Select "Science 101" or similar you could call up a list of students in Science 101 any ideas?

If I have cents that doesn't make it show up correctly

well thats annoying

Under normal circumstances I would have it print red when negative but I actually want it to do the reverse and print red when positive be black when zero and have green with (....) when negative to show that we ow them money.

I currently have the calculation field: Total Balance Remaining Calculation = Case ( Total Balance Remaining > 0 ; TextColor ( Total Balance Remaining ; RGB ( 250 ; 0 ; 0 ) ) ; Total Balance Remaining = 0 ; TextColor( Total Balance Remaining ; RGB ( 0 ; 0 ; 0 ) ) ) Where the Field Total Balance Remaining is a Calculation Field with the formula: Total Amount Owed - Total Amount Paid what am I doing wrong to make the text change colour?

I figured it out thanks anyways

How do I set the graphics field in layout mode? I am confused on how to make this work.

Yes a flag in a diffrent field I'll try those out and see if they work.

New problem if the still owe money... I currently have the field go Balance = Total_Amount_Due - Total_Amount_Paid I need to have a flag either a graphic or Red text come up and say that they haven't paid.

Thank You Queue as always...

I am currently designing a database where I have one table with classes and one table with students, I need to know how to get the Cost of the classes from classes and do a total owed amount on the student, any help would be aprricated.

I take it that & and "and" are diffrent in FM I was trying to do it with "and" and of course it gave me boolean thanks for the help

I want a field to look up two values a first and last name and have a full name value with a space between the two I know this is possible with a merge field in the layout, but that won't let me do a proper layout, is there any way to do this?

an alternate is perform find [options] is it not? I mean I don't need to set the field if I have it.

I am trying to use a script to generate a report in a list format, showing only those records that are not checked, is there a easy way to do this? BTW thanks for the help Queue.

To make a report using only the ones that have it unchecked I would do a find not equal to value of the box?

I understand the usage of value lists but if it's only a value list how do I do a query on it since a query can only be pulled on a field?

Okay got that part but how do I make a check box with only one selectable option?

I am currently trying to make a report that looks to see if a checkbox is checked or not, but am having trouble everywhere I turn, including even making the checkbox value, I understand how to do it logistically, just not in practice... if anyone could help me and wishes to try and discuss the details over email please email me at pawndisc@aol.com if you would rather type the reply here that is fine as well. Thank you in advance

I would like to know how to filter specific text from an area, specifically, I want to filter the @webaddress.com from an email address but still show the sombody part of sombody@webaddress.com if anyone could help me it would be a big help