Problem has "many" cycles

[lcook1974]

Good afternoon,
I am having a major internal brain explosion...

I can't seem to get my head around "how to" get the cycles right for a problem.

What I am looking for is something like this...

user will open form and fill out the problem information (frmProblem)
then fill out the respective team members
then fill out the "PDSA" portion (Plan, Do, Study, Act)

once that portion is complete....there could be another "cycle" to the same problem.

For Every problem there can be "many" cycles
For Every Cycle there can be "many" Plans
For Every Plan there can be "many" Dos
For Every Do there can be "many" studies
For Every Study There can be "many" Acts


I would like them to be able to hit a button that says "Add new Cycle" and have all the subforms (PDSA) automatically go to a new record.

How do I do that?
Should my table all have a "problemID" and "cycleID"?

Open frmProblem to get the view I like...

I'm attaching the database for you to "rip up"...

Any insight, push, shove, nudge in the right direction would be great

Thanks!
Larry

using Access 2003

 

[jzwp22]

Re: Problem has "many" cylces

Based on your description, your table structure is not quite correct. That needs to be fixed before you work on your forms. I have updated your DB based on what your described; the modified DB is attached. Please take a look at the relationship window.

 

[lcook1974]

Would you believe I had it like that before, then changed it...

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

I kept getting an error where I had to have something in each table and they wouldn't necessarily have the information yet.

I'll give it another go.

Thanks jzwp22!!

Larry

 

[boblarson]

I kept getting an error where I had to have something in each table and they wouldn't necessarily have the information yet.

That can be a symptom of either incorrect setting of Referential Integrity or using the wrong form/subform structure.

 

[lcook1974]

I'll check it out...

Thanks Bob!

 

[lcook1974]

Thank you gentlemen!! I think I was over thinking it...I'll start a new thread for my other issues on this DB.

Larry

 

[jzwp22]

You're welcome! Let us know if you need further help with this thread.