forms/subforms/tabbed forms

[Ollie_3670]

I have Access 2007 and I'm creating a student admissions database.

One student can create one application per year
So over several years one student can create many applications.
Each application contains three Course options

How do I (or can I) create a form which I can add the students information at the top of the form and view each application to the university in a bottom section. Which is tabbed off, by year

As you can tell with my recent numerous threads, I'm no Access expert and in view of my poor problem description, I've attached a lovely .jpeg..a conceptual design if you may!

Cheers again

 

[Magster]

You have a simple one to many relationship as far as I can see. You could use the wizard to create (create your query first) the main form and a subform within it.

I've used the tab structures a lot when I have multiple one to many relationships and I want to work in one form. I think you may be making things harder with tabs.

 

[Ollie_3670]

It's not quite a simple 1:M relationship as there are multiple tables, it's more like 3, 1:M relationships with Application_Line being the intersection entity

1 student can have many application headers
1 application header can have many application lines
1 course can appear on many application lines

My problem is, I need a way in which my client can view a student's details and application's to the university (over several years) without having to chop and change between forms.

The only valid solution I can see is the one I proposed, unless there is a simpler way?

 

[Magster]

I had a similar issue a while back so I searched through my old posts and found this one which sounds like what you may be talking about. Please check it out and let me know if you have any questions that I could help with.

http://www.access-programmers.co.uk/forums/showthread.php?t=162609

 

[CEH]

Sounds like you already know the relationships......

1 student can have many application headers
1 application header can have many application lines
1 application lines to many courses

Each tab would simply be a subform based on a criteria using date as filter.
So build your form with subforms... then add your tabbed box from tools...
If I remember correctly (haven't done a tab in a while) Access doesn't like dragging subform or fields to tabs... but copy and paste your subforms onto each tab.

 

[Ollie_3670]

Thanks a lot guys, modelling and normalising is easy..It's just the UI that gives me trouble! This will form the main meat of my application so hopefully I can get something set up!

so basically the idea is:

One form, one subform. In that one subform you can have multiple tabs grouped by academic year.. Right, time to get on it!