Linking multiple fields in a table

[mjf8563]

Hi I have a question but I am not sure if it's possible. I am trying to link two fields with multiple values. I am making a class table that will list class names, class id, credits the class will offer, Section number, and campus. I want to link the section number and the campus together. For example if I pick section A it will show campus A and if I pick section B it will show campus B. I'm not sure I can do that but I have 16 different classes listed now and I want it to show that it is only 8 classes or something in that nature.

Thank you in advance for any help.

[orange]

Hmmm. I think you are a few steps away from "linking fields" etc.
I strongly suggest you work through this tutorial re: Class Info from RogersAccessLibrary.
The tutorial outlines a process to design a database (tables, attributes and relationships) based on a clear description of the business requirements. It should take you less than 1 hour to do and understand the tutorial and the concepts involved. The Hernandez process can be used with any database.

To get the experience you have to work through the process, but you will learn.
The tutorial does include a solution.
Good luck.

[mjf8563]

I'll do that later today. Thank you so much for a fast response.