EDumas

Ok I have set up the table and enrollment portal. The only problem left is to write a script to populate the Enrollment table with the Student-Class information. Being new, I am not totally clear on writing scripts. I understand what they do and can do the very basics (I have a lot to learn). Can you tell me what I would write for this script? Thanks, E.Dumas

Thanks, Ender. I thought the same thing and I have even tried to figure out how to create that file. It would mean I would have to duplicate records for each student's classes (ex. student a has 3 different classes then there would be 3 records with just name, reg. and class number)Any suggestions on how to convert data from one file with seperate class fields to another file of records that are populated with all classes in one clase field? I have been studying this website for almost 2 weeks and have not been able to hit on the right topic that would help in this dilema (maybe being new to FM doesn't help). And to tell you the truth, this forum site is great. I have cloned the database and have that copy to play in 8.5 and the original is 5.0. What a nightmare that would be to upgrade data and then have to go back. I have convinced the org that they need to upgrade, but it will not be until late Oct. Thanks EDumas

Hi Everyone. I am hoping someone can answer this question for me. I was given a responsibility to register class attendees and provide enrollment lists to the teachers. The database is in FM 5.0. I have never used FM before 3 months ago. I was able to make the database work except one piece. Problem: I can't create the enrollment sheets. I have a table containg class information (number, teacher name, etc) and I have a table containing student information (name, address, classes being taken, etc) Then I have a layout in the class database with the enrollment information and a portal set up to list all the students in each class. IF a student signs up for more than one class I can not capture all of the data due to the student database having different fields for the class data (so there is one record per student with multipe class fields - class 1, class 2, class 3, etc) I need the information from all class fields to be pulled up in the portal. Originally, the database was stuffed with a C+ file and that file was not given to me with the database. The person will not provide it and there is a lot of hard feelings between them and the non-profit organization I am doing this for. Since the database was in FM 5.0, I am using this version, but I have downloaded the latest version for trial in hoping this would help me (then I would have the org. purchase the latest ver.) Any help would be greatly appreciated. Thanks EDumas