I'm guessing with the issue of dependencies and sequencing, you might want
to take a look at project management software, rather than trying to
reinvent it in Access.
Otherwise, I don't think I could help more, other than to suggest doing a
search on-line to see if someone has already dealt with this.
Regards
Jeff Boyce
Microsoft Office/Access MVP
We aren't there. We can't see what you're looking at.
It all starts with the data! It's pretty tough coming up with specific
suggestions if we don't have any idea how your data is structured.
Regards
Jeff Boyce
Microsoft Office/Access MVP
- Show quoted text -
The table I want to have with dependant data is like so:
tblMECAPPDump
SSHELO+JC PrimaryKey
Stage# Text
Station Text
JobCard Text
HoursReqd Number(Dbl)
HoursWkd Number(Dbl)
Job% Number(Dl)
Seq Number(Dbl)
Op Number(Dbl)
Technician Text
ModifiedDate Date
State Text
What I want is to show JobCard A is dependant on JobCard C, Job D and
Job F to Op 70. I would add a field or a another table that shows
this info and then have it displayed in like a Outline view style
report. Later down the road, I want to be able to display it in a
HTML web page with "roll up" capability. This info is always being
asked by upper management and they are always having to wait for an
answer as the specialist technician is required to answer the
question. If there was a report that showed, material restraints and
how many jobs are dependant on this job card and how many hours it
puts the production behind it would be beneficial.
