Switching between files

[mleiser]

I have individual files for each school year. I have one file that contains pertinent info of all the students of all the individual files. Each record in the the "all" file has the year the student was here. What I would like to do is have the ability to click somewhere on the student ifo line in the "all" file and automatically choose and go to the appropriate "year" file ito that students record and be able to come back to the "all" file. Hope this made sense. Any ideas?

Mike

[bcooney]

It sounds like a poor database model, actually. Are students only there for one year and only one year?

Perhaps you could write a script in the "all" file that does something along the lines of (this is not actual script, just pseudo-code)

If Year=2000,

go to related record All to Year2000StudentID,

elseif Year=2001,

go to...

endif

You'd build a relationship that has two match fields, the Year and the StudentID.

However, I'd say a redesign is in order.

[mleiser]

Thanks. We actually have one post high school that is for one year. So your idea would work. Can the file to go to be some kind of variable so we could stick in or concatenate a field from the record to pick the right file?

Mike