Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

Newbie with no brain left and relation problems


This topic is 5497 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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?

Posted

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

Posted (edited)

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 by Guest
Posted

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

Posted

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.

Posted

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

assessment.jpg

dashboard.jpg

  • 3 weeks later...

This topic is 5497 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.