|
any access 2003 pros in here?
|
View this Thread in Original format
| malek |
I've been pulling my hairs over this problem with access 2003.
I'm sure its not hard to do, last time i did some advanced access was in cegep :o
Is there anyone here who knows his way around subforms and 3 n way tables??
I need to create a form with two subforms embedded into each other.
If you have an idea of what I am talking about, please answer back!!
Thanks
P.S. We all know ACCESS 2003 sucks bla bla bla, but the clients wants it this way. |
|
|
| 404 Science |
| good luck man;) |
|
|
| mmx |
| What exactly are you having trouble with? Subforms are pretty much drag-n-drop to implement. Is this a school project? :) |
|
|
| malek |
Basically:
I have 3 tables:
Curriculum: [curriculum_id]
Courses : [course_number]
Lesson: [Lesson_id]
the bracketed names are the PK.
The user needs to create a new curriculum, choose which courses he wants from the catalogue, then choose which lessons from each selected course.
So I have created a table that goes like this:
CurriculumCourseLesson: [curriculum_id,course_number,Lesson_id]
The primary key is the all three FKs together.
The main form lets the user to select a curriculum, the subform lets the user choose the courses he wants. Then there's another subform inside the Course subform that let the user choose which lessons he wants. |
|
|
| mmx |
| Do you have to design the system this way? Can't you just create simple lookup tables (using list boxes) instead of subforms? |
|
|
| malek |
I do not give a how its made, it has to work :)
Can you imagine this is for B****g, plane maker:p |
|
|
| Allied Nations |
| I'm too leet for access 2003 :o |
|
|
| malek |
| quote: | Originally posted by Allied Nations
I'm too leet for access 2003 :o |
sure:sadgreen: |
|
|
|
|
