Hi all,

I'm a real newbie and I would really appreciate your help.

I have "produced" a database to record students assessment progress.

I have 3 tables.

The first:

USERS

Student_ID

First name

Last name

etc

The second:

ASSESSMENT

Assessment_ID

Student_ID

Date

The third

SKILLS:

Assessment_ID

Skill 1

Skill 2

etc

I then produced a layout that pulled that information together.

LAYOUT OVERVIEW

Student_ID

First name

Last Name (from the user table)

Skill 1

Skill 2 ( from the skill table)

I produced a dashboard.

The teacher can add users and these appear on the users area! no problem!

From the dashboard they can click onto assessment.

This takes them to the assessment layout.

This includes

Assessment_ID (from assessment table)

Student_ID (from assessment table)

first name (from user table)

Last name (from user table)

I then placed a button feature on the student_Id so that it goes to the overview.

This all works!!

However,

It shows just 1 layout called the overview. They all point to the same one.

I wanted each kid to have there own overview sheet so that I could assess each one, but every kid seems to just share the same sheet.

I hope you understand all of that!! I'm not sure I do!! I think its a relationship problem, but not entirely sure.

All I know is that if I don't solve this soon there will be a relationship problem with my wife!!!

Thanks in advance

I believe your Skills table should have one record for each skill a student has. It's not quite clear if those skills are drawn from a known list, or if they could be anything - and what exactly goes into that field: is it a description like "skating" or is it a grade?

Thanks for the quick reply.

There are 8 levels of skills with approx 12 skills

Within each.

These are statements that come from the national curriculum.

I have made the skills table and populated it with all the

data. At the moment it is tabbed from level one through to

level 8.

I hope this gives enough info.

Thanks,

Splodge

Sorry, I wasn't addressing your question. What table is the Overview layout based upon? If it is Users, you could make the button just switch to the Overview layout.

Edited December 16, 200916 yr by Guest

Thanks again, I'm in my kids carol service so this is great!

The overview pulls data from the users but also the assessments.

Unfortunately, I think that's my problem. I can't find a related table!

Should I make a new one pulling the data or is it ok that

The overview is a layout?

Thanks,

Splodge

I am afraid I am bit confused here. Although a layout can also display records from other (related) tables, it is always based on a specific table (or rather table occurrence) - you can see this in Layout Setup > Show records from [...].

I am not sure what exactly your "dashboard" shows. I tend to think it should be simply a layout of Users, but I may be missing something in your description.

The dashboard is a layout I created with 6 buttons on it.

The teacher will hopefully just see this and click onto the relevant button.

The buttons include, add user, edit user, assessment etc. So they just link to my tables.

The overview layout I produced by using the USERS table - pulling Student_ID, first name and last name and the SKILLS table where I pulled the fields, skill1, skill2 etc.

I do have a third table called ASSESSMENT

This has

STUDENT_ID - relationship to USER

ASSESSMENT_ID - relationship to SKILLS

Date

This is where on the ASSESSMENT layout the teacher can click onto one of the users and be taken "hopefully" to the related record.

Unfortunately, they all point to the same layout and not related record and I think thats where I'm going wrong.

I hope I'm making sense and thanks for keeping with me.

Splodge

Whooppppeeeee!! It seems to be working!! Thanks for your help. I needed to link to th erelated record!! I know, obvious when you know how.

Thaks again,

splodge

;)so helpfull