Search results

Here is my DB: What I am trying to figure out is the best way to have, when the button is pressed, class form open with ONLY classes relative to the session selected. How can I do this?

This is a completely different topic now, so I'm going to move my question over to the forms discussion board.

How would I set it up to display the classes only offered in whichever session was selected?

So I should create another form for classes that will be opened when the button is pressed?

Okay, got it. I will do those things next. If I could ask you another piece of advice... what would be the best way to set this up in my form? I would like to have the student's info and class info separated onto two tabs for easier maneuvering. Should I create subforms with the class/session info?

Okey-dokey, here's what I have now. Yeah?

I just found out--YES, one class may appear more than once per session. Just not per period.

OK, I created the above tables... To avoid confusion, here is how the whole program is set-up: Session1: Period 1: -Class 1 -Class 2 (etc.) Period 2: -Class 1 -(etc.) Period 3: -Class 1 -(etc.) Period 4: -Class 1 -(etc.) Session2: Period 1...

We use the same. Session 1 has Period 1, 2, and 3, and Session 2 & 3 have the same.

Another thing... if I am to create another one-to-many relationship for each Class, how would I go about that? There are multiple classes (what you refferred to as activities) per session, per period. However, some classes are offerred in more than one session. What would be the best way to...

You are right, there are 4 periods per session. I believe I will need to create another table for periods, then... Does this look right so far?

Hello. I have set up a one-to-many relationship between my tables with a junction table. I am new to junction tables but I believe I set it up right. I have created a query from the tables, but the query isn't returning any records which leads me to believe I set the relationships up wrong after...

Here is my relationships report, can you look at it and tell me if it appears to be set-up correctly? Thanks bunches!

Thank-you... that helps a lot. Now that I'm learning about how the junction tables work, what would be the best way to set that up in a form? Should I use subforms?

Okay... not sure how to set-up junction tables with many-to-many relationships. Here is my DB, I am using Access 2007.

I've set up a one-to-many relationship between the Registration/Office info table with each of the other tables... is that what you are asking?

Hi all, I need help. I'm going crazy trying to figure out the best way to accomplish what I need... I work at a community college and am currently working on building a DB for our summer program enrollments. The classes we offer are broken down into three sessions, so I have a table for session...

Nevermind, all is well. Thanks again!

Thank-you! That works.

Help! I have created a form with a subform in it. When I change the way the subform looks in Design View, it looks like this... But when I switch to Form View, it looks like this... I don't want that! I want it to look like a form, like it does in Design View. How can I do that? Thanks in...