Unsure how to Fix

[ngwaltne]

Beginner Problem here:

I have about twenty dbs that individuals work on. As they enter data it, through a relationship, is assembled on a master document.

I set up a new quarter today. Doing this exports an alpha list of people and basic information and sets up the new quarter. (The loop script includes the master document.) Works fine. However, because of the relationship the master document does not create a new blank quarter. The new quarter displays the information from the previous quarter. This is only the second quarter I have used this database.

I see the problem, but because I am a beginner, not sure how to approach this.

[Fitch]

I'm pretty sure that the lack of response to this question is due to your not providing enough information to make any kind of guess.

I know what a quarter is, but not what "set up the new quarter" means in this context. Every FileMaker project is unique. And, depending on the developer, some are more unique than others...

>>...because of the relationship the master document does not create a new blank quarter. The new quarter displays the information from the previous quarter.

You're going to have to provide more detail on the scripts/fields/relationships involved. What's a "blank quarter?" A field with a date in it? Or a related file with a record for each day of the quarter?

[ngwaltne]

Beginner Problem here:

I have about 20 teachers that do the report card.

There are 20 dbs one for each school subject area such as English, Math etc.... I set up a school quarter (ex. Winter 3 third quarter) and the students information is exported from the student file with ID number and all as the 3rd semtester. This is done with a loop script for each subject area.

Teachers then access their area, English for example, They perform a find for a group (class) and that year and semester. They enter the grades and then repeat the process for their next class.

All subject area grade fields are related to the master report card which is an 11x17 document. In the master report card the semester is also set up. Here in lies the flaw. As I went to set up the next semester the subject areas were fine. The find for the new semester brought up the found set, and it was ready to go. However, the master report card because it is related to the subject areas shows the data for only the first semester.

I hope this is clearer. I think this is a fundamental design problem. Being a beginner, I did not anticipate this. My problem should have been posted under a design category, sorry.

Thanks in Advance

Norm