S
SMac
I have 2 databases, an Engineering db and a Tooling db. Usually part of the
Engineers entry is to request a Toolroom Work Order (in the Tooling DB), I am
able to export the data from Eng to Tooling via an Append query but after
that I would like to extract the Log# that the Tool db gives the request back
into the Eng db.
I tried the link tables but I am only interrested 2 fields out of the Tool
db, what is the best route? Possible VB or can I use another query?
Help is much appreciated!
Stacey
Engineers entry is to request a Toolroom Work Order (in the Tooling DB), I am
able to export the data from Eng to Tooling via an Append query but after
that I would like to extract the Log# that the Tool db gives the request back
into the Eng db.
I tried the link tables but I am only interrested 2 fields out of the Tool
db, what is the best route? Possible VB or can I use another query?
Help is much appreciated!
Stacey