Task Tracking Database

[TexasBill]

I know just enough to be dangerous but most times get frustrated and
translating what is in my head to Access and actually have it work. I'm
stuck so searched and found this forum. I'm hoping someone will have pity on
me and provide some assistance.
- I'm trying to create a database that tracks actions (suspenses/projects)
through the organization. The task would go from the front office (DPW) to
the next level (DPWC) then to DPWCM. There are various four and five digit
levels. Each subsequent level would add their due dates and project officer,
etc.
- I created tables for each level - each table has a project ID that is
common across all tables but the other fields in the table are unique to that
level.
There is an input form for each level and I've gotten the records (that are
assigned to a specific 3 or 4 digit office) to show down to the 4 digit.
- The problem is at the four digit, I try to fill in the information
specific to that level and save the record -- access says I can't add or
change a record because a record in the (DPW) first level table has to exist.

- Here is the funny part - I can go to the table for the fourth digit and
manually put in the record ID and then go back to the form and input the rest
of the info and the record saves.
I know this is a long post but appreciate any assistance.

 

[Cheese_whiz]

Hi TexasBill,

I think you might need to reconsider your table design. To me, a task is a
task is a task. The fields in the task table will allow you to differentiate
tasks from one another. For example, one field may be 'task level' and that
field would be the basis of any operation where you needed to separate out
tasks for a particular level (office).

It's kind of like a cars database and you seem to be saying you need a
separate table for sports cars, a separate table for minivans, a separate
table for trucks, etc etc. That's not the way it works.

That's just a quick take based on what you provided. I could be wrong.

CW

 

[TexasBill]

LOL - all I can say is "Duh" - guess I was too close to it and to through
come Friday to see that. I'll redesign the table structure and let you know
how it goes.

Thanks Again

 

[TexasBill]

Thanks CW - that worked perfect. The new table structure allows me to do
everythig I needed to .