T
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.
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.