dynamic field information

[morrisonmuzk]

Thanks for reading my question!!!

I am working with creating a weekly lesson plan book to use in my class. I have a unique field that I am using for each week( like week 1, week 2, etc.) as I need to keep all info all year long. I am trying to avoid making a layout for every week and would like to set up some kind of field that would import/show the information from week 1, let me edit it and still save it in the week 1 field, then if I wanted week 2 info, using a button maybe, I could see the week 2 info, edit and save it...

I've tried using the 'set field' command using scripting and I can see the data from week1 or week2, but can't edit it.

Any ideas would be appreciated!!!

thanks,

Brendon

[CyborgSam]

Brendon->

I'm not sure why you need a unique field for each week instead of a unique record. Can you put this data in a second related file and have each week be a separate record? Then adding/editing weeks would be easy.

If I'm not understanding your needs, please elaborate!

Sam

[bruceR]

You do not need a week 1 field, week 2 field, etc.

You need a "week" field. Then you put "1" or "2" or whatever into it. The other field is "Lesson" .

[morrisonmuzk]

Thanks for the replies...here a bit more info to clear things up (maybe)...again, any ideas, even changing how I'm doing it, would be cool...

ok, each record I'm keeping is based on one student. Within each student record, there are many parts like homeroom teacher, school they attend, lesson day, lesson time, grades from first quarter, grades from second quarter, etc...I use this database with many layouts to easily enter grades, print schedules from, add general comments, ect...

Now, I'm trying to create something that I can use/enter information on a weekly basis...for example, if I'm absent from school, I can just go to my layout that will list the student, lesson time, instrument, and the assignment from the last time I saw that student. This list will show an individual record for each student, in a list type of view, sorted by lesson time.

what I'm trying to do is create something easy (I know...easy doesn't always work) that will let me pull up lesson material from the previous week, but I also need to keep every weeks lessons for each week all year. That way if I'm ever questioned by a parent/principal about what have I been doing with a student, I can easily pull up all information.

I hope this clears up a few more things...if not, let me know and I can even send out a copy of the database to let you see...

thanks again!!!

[bruceR]

Easy is fine. You need to have one record per student in the Student file, and a related file "Lessons" with StudentID, Week, Lesson, etc. You have a classic one-to-many relationship, that's what you need to create with the Lessons file.

[morrisonmuzk]

Bruce,

Thanks for the idea/suggestion. I would have thanked sooner, but have been swamped at school since last week. I've started the 2nd database idea - wish I would have thought of that sooner myself!!!

thanks again,

Brendon