I am currently developing a databse for my school which will track children's academic progress from Kindy to Yr 6. I have got a front page which I want to allow people to work with a specific type of record

eg Year 3

or Year 6

or 3J

or 6A

Each of the examples is a field within each record and I need a script which will allow teachers to work with a cohort of children they choose.

Is it possible :?::

Many thanx

Poida

It's called a Find. You enter Find mode, enter the criteria for the records you want to work with, and hit the "Find" button.

I was hoping to create a script that would do this automatically with a button to run the script. Ive tried a few scripts but havent had any luck getting it to work exactly right!

Hi,

You could use a relationship for that. Each teacher could see and works with its related students using a "go to related record" script at start.

The only real reason to create a script is to perform certain finds, like finding all 3J or something.

In that case, perform the find, then create a script that performs a find. That will lock in the find you just performed.