T
tracktraining
Hi All,
I am running out of possible reason for the problem. Please help. Let me try
to explain.
Background information:
EmpdocStatus table --- has all the record assigned to each employee.
Update form -- has only the doc+latest rev assigned to each employee (from
the latestRev query)
DocInfo table --- contain doc+revision
Case 1). DocInfo table is a table that is part of the db. First I assign the
doc+revision to employee. Then I change the revision of a doc, then assign
the doc+new revision to the same employee. So my LatestRev query return back
the latest rev assign to that employee. So that works great.
Case 2). I delete the DocInfo table. I link a table called [Part Master] via
odbc. Then I write a query called DocInfo to get Doc+revision from the part
master table (so this should act like the DocInfo table from Case 1). Then I
assign an employee a document+ current revision. It shows up on the UPDATE
form. Then I maually change the revision to a higher revision (i.e. from A to
B) in the part master table. Then I assign this doc+new revision to the same
employee. Now my UPDATE form doesn't give me the latest rev. it is still
showing the old revision. So I don't know what is the problem with my
latestrev query? Why doesnt' it work like before I linked the part master
table?
Please help.
Thanks,
Tracktraining.
I am running out of possible reason for the problem. Please help. Let me try
to explain.
Background information:
EmpdocStatus table --- has all the record assigned to each employee.
Update form -- has only the doc+latest rev assigned to each employee (from
the latestRev query)
DocInfo table --- contain doc+revision
Case 1). DocInfo table is a table that is part of the db. First I assign the
doc+revision to employee. Then I change the revision of a doc, then assign
the doc+new revision to the same employee. So my LatestRev query return back
the latest rev assign to that employee. So that works great.
Case 2). I delete the DocInfo table. I link a table called [Part Master] via
odbc. Then I write a query called DocInfo to get Doc+revision from the part
master table (so this should act like the DocInfo table from Case 1). Then I
assign an employee a document+ current revision. It shows up on the UPDATE
form. Then I maually change the revision to a higher revision (i.e. from A to
B) in the part master table. Then I assign this doc+new revision to the same
employee. Now my UPDATE form doesn't give me the latest rev. it is still
showing the old revision. So I don't know what is the problem with my
latestrev query? Why doesnt' it work like before I linked the part master
table?
Please help.
Thanks,
Tracktraining.