Jump to content

Viewing category from another table


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

Recommended Posts


I am not sure I am in the right section of this forum, if this post should be in a different category let me know and I'll change it.

Here's my problem:

I currently have one table called STUDENTS.

In this table there's a field called CLASS (from the student).

Now, what I am trying to do is get a list of all students in each class. I think I need a second table called class and make a field CLASS ID. But when I try to make this I keep getting a many-to-many relationship, result: on the layout my data is invalid...

How can I filter these students from each class (let's say in a dropdown list), so I can choose which one to edit?

Thanks in advance for all your help!


Link to comment
Share on other sites

im confused, do you want to edit the students or the class... or the students in a particular class?... if the last why dont you just do a search...

Anyway truth be told you should probably have a seperate table for classes than students and have a relationship between classes and students by the class name or class ID or something which you could choose from students... that way you could view a list through a portal of all students in that class from a layout that takes its info from the class table... and you could also store more detailed information about classes and draw that out through the relationship as well.

P.s. if you dont want the relationship to be many-to-many set the field you want to be the "one" to store a unique value.


Link to comment
Share on other sites

This topic is 5753 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.