Adding Records

[bruce1949]

I have created a template that allows the counselors to add students individually to classes according to the class period, grade level, and student ID. I would like to add multiple records at once. For example, I would like to add 6 students to period 1 with 1 input and have the class total reflect this input. I would greatly appreciate any assistance.

[Maarten Witberg]

Hi Bruce.

 

Do I understand correctly that you wish to add multiple records that have some fields in common, such as period, level etc? This is possible in various ways.

 

The template seems to be a student overview per class am I correct?

Are the students already entered into the database somewhere?

 

Could you tell us a bit more about your database setup so far, is it single file or is it relational?

Which version (7 or 6 or 5.5 or earlier)?

 

kjoe

[bruce1949]

Yes, I would like to add multiple records that have only one field in common which is the period the students are in. Currently, a counselor can add a student one at a time to the database by entering the period, grade level, and student ID of that student. I would like to be able to make a batch input to a period. For example, if I have 6 student who need to be added to period 1 I would like to enter the number 6 into the database for period 1 and have it create 6 new records for period 1. I would like to have both options, to either individually add students to the periods using grade level, student id, and period or to add multiple student records knowing only the period they are in. Thanks Kjoe for your help. Looking forward to your solution.

[Maarten Witberg]

[ QUOTE ]

For example, if I have 6 student who need to be added to period 1 I would like to enter the number 6 into the database for period 1 and have it create 6 new records for period 1.

 

[/ QUOTE ]

 

1. the following creates empty student records (gNumber) for a given period (gPeriod)

the records won't have student IDs entered automatically unless you have a serial number field that auto-enters a serial number.

 

Code:

---

set field [gCounter, 1]
loop
new record/request
set field [Period, gPeriod]
set field [gCounter, gCounter+1]
exit field if [gCounter > gNumber]
end loop

---

 

gcounter, gperiod (the period in question) and gnumber (the number of records to add) are global fields. the user sets the latter two.

 

2) the following provides overviews of existing student records in a periods file if you have a relational setup.

make a relationship between a student's file and a periods file based on period number. then draw a portal in the periods file based on this relationship. Any student record that has the period number corresponding will appear in the portal. You can base counts on that relationship also:

StudentsForPeriod=count(relationship_name::StudentID)

 

that way, all you have to do is update the period for any student that is enrolled and you will have period overviews.

 

the period could be a singular (unique) number. Be aware that if you are using two groups or courses for period 1, then the relaion won't be any goor. Then generate a code or serial using FM. This could be anything from a simple serial to a periodnumber and year. Or if you have multiple courses in a period, an ID field per course.

On the create-student-records side you can use a value list of these codes combined with course names.

 

hope this helps.

 

kjoe

[bruce1949]

Kjoe,

 

Thanks for your help. I will try this solution.