Dear All,

I'm working on a school system and all going well so far except for one issue.

I have a student table, now what i want to do is to generate an "Evaluation Report" about every student after each quarter, here are the details:

1- I want to create an Evaluation template, where i can create a set of questions under different categories e.g: Technical, Admin etc.. and under each category in the report there are a set of questions with some answers (all checkmarks).

2- I want from the students screen to click a button, open another layout with the student name, select the Evaluation Template i already created (from question 1), then all the questions start to generate in a portal with all the checkmarks (Excellent, Good, Average, Bad) so i can fill the answer then send it to printer or e-mail to give it to parents.

I would really appreciate any feedback to help me design the model above.

Thanks

This is not a trivial task. Do a search on these forums for survey and you should come across some examples.

Hello Mr_Vodka, I already did but didn't find anything relevant to what i'm trying to do

Would appreciate any help.

Thanks.

Sometimes you can find things easier by using the Google search. Try using this in the search bar survey

This is an old thread but it may help you get started...

http://fmforums.com/forum/topic/49072-surveys-and-relationships/page__p__229378

This may give you some ideas; it's a bit rough around the edges, the Graph isn't tidied up, and the use of ExecuteSQL is maybe a bit adventurous (no guards against table or field renaming), but the data model should do what you need.

StudentEvaluation.fmp12.zip

Thanks will try these and keep you posted.

Thanks again

Hello Mr_Vodka, I already did but didn't find anything relevant to what i'm trying to do

Try:

http://fmforums.com/forum/topic/45972-another-survey-question/

in addition to the link mentioned in post #5.