Hello,
I have an AppleWorks DB with 255 fields (the maximum allowed): it is the place I put presences, absences and the test results.
This first DB has 180 fields for presences and absences; all are of the type "Value list" and all have 3 initial options: ".", "f" and " ". The default value is ".", of course.
As one can see, it is a dynamic DB: it counts the absences and calculate the final grade (0~10) of each 3-month period.
The second DB, that I made for the others teachers, and print one layout for each class, with the number, the name and 60 "value list" fields, exactly like mine.
It is a static DB: the teachers fill the data by pen.
Although my exclusive DB is more complete than the school’s, in this year I fill first (with the names of the students)I the school’s DB and after I selected and and copied the groups of students that I have to my DB.
Since the 60 "presence/absence" fields have exactly the same name and are of the same type, they are copied with no problems.
But the other 120 "presence/absence" fields that did not exist on the school DB will not show the default value that I need: "." .
I can get inside each of the 120 fields and select the value that I need: “.” , but I have around 90 students; so I would have too much entries to make by hand: the total changes will be 10,800 .
The first 60 “Value list” fields for presences and absences I named ‘1’, ‘2’, ‘3’, ... ,’60’ and the others 120 fields of theis sama type, were named:
'2.1', '2.2', '2.3', ... ,'2.60' and '3.1', '3.2', '3.3', ... ,'3.60' .
What I want is a way to "update" the fields '2.1', '2.2', '2.3', ... ,'2.60' and
'3.1', '3.2', '3.3', ... ,'3.60' to show the default value ".", based upon another "Value list" field named 'Position2' that has the options "Regular", "Cancelled", "Transferred", ...
IN EACH RECORD it should look at 'Position2' field and if the student was classified as "Regular", the fields '2.1', '2.2', '2.3', ... , '2.60' and '3.1', '3.2', '3.3', ... , '3.60' should show the default status that is "." (Present).
There will come the other problem: when the class arrives, and I verify that some student is not present, I need to be able to change that to "f".
Maybe this way is not the ideal; problably there is a AppleScript that write for me the default values in those 120 fields.
If you know how to solve this, I thank you in advance; if you don't, thank you for reading this,
Jorge Lucas ( Not the "Star Wars" guy)