dchuhta1

First of all.. thanks so much for your help. I really appreciate it. Alas... I think I've finally gotten it! I hate to close this case though.. stay tuned! Thanks again!

By putting a portal on Scores with the student's name, ID, etc., will that associate the data in the scores fields with the student?

Thanks, but actually, I have that already. I have portals on the Student file showing a summary of sorts, from all of the score files. This still hasn't solved my initial inquiry, however, as to eliminating the need to import the 3000 students into all of the files...

(I have searched other posting to find the answer to this, but I haven't found one that really matches what I am attempting. If the answer lies elsewhere, please aim me in the right direction.) I am attempting to create a "system" of databases for the purpose of collecting student scores. I envision one database that holds of the students (we're talking about 3000 or so), including FName, LName, ID#. Then, I'd like to have separate databases to hold science, social studies, etc. scores. (In all, there would be six tables; one master, and five related.) My question is how do I set them up so that I don't have to import all 3000 students into each of the five related files (and consequently can make changes to student roster in the master table, and then not have to do it to all of the other files)? In addition, what I'd like to be able to do is say, in Science, do a search for a student name, and have the student info (FName and ID) automatically be pulled in. I've tinkered and tinkered, but I can't get it to work, without having all 3000 students in each of the files. (Since I'm fairly new to relations, etc. please try to be as detailed as possible -- I REALLY appreciate your help!)

How do I get the portal to stop repeating the contents of the first row (into the second row) without having the contents extend a bit outside of the row boundary?

Ok.. you lost me. Let's get real so that I'm no longer talking about fruit, I'm talking about what I really want to make. I'm a teacher, and I'm trying to develop a way to track student grades on assessments. When I choose the "Discipline" menu (say I select Science from that menu) I want the Assessment menu to then only show the what I have defined as the science assessments. How would I go about doing this? What value lists do I have to assign to what? What do I have to create first? I've followed the instructions for subsets in FM help, but it doesn't seem to do the trick. You lost me on the left-hand, right-hand thing too. I guess I'm a very novice user. Thanks for your help. I appreciate it.

I am trying to link pop-up menu value-lists. For example, if in the first field, "Color" I chose "Red," the menu for the field "Fruit," would only show a value list called "RedFruit." If a different color was chosen, a different subsequent menu would appear.

Post deleted by dchuhta1