Scan incoming data and cross match against a table for a value

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Ok here's my dilema,

I have these 2 tables:
tblProjectClient
tblDataDownload

In the ProjectClient table there are 2 fields:
[ProjectMgrPC] & [Client]. Each client is assigned a
Project Manager.

In the DataDownload table there are about 15 fields, but
it also has a [ProjectMgrDD] & [Client] field.

When data is eventually downloaded from our Oracle system
to this Access table, all of the fields will be filled in
except for the [Project] field.
Is there a way (and I'm sure there is), to scan the Client
field of the Datadownload table, cross match the value in
that field against its same value in the Client field of
the ProjectClient table, and then write the [ProjectMgr]
value assigned to that particular client to the
[ProjectMgrDD] field of the DataDownload table?

If so, then how would it be written and where? Should it
be a Module assigned to some sort of triggering mechanism,
attach it to like an On Update or Click expression?

I would appreciate any help on this perplexing task.

Thanks,

Ron
 
Why would you have the field twice? (I can think of a
good reason, but I want to hear yours).

You could just use a query to add the two tables together,
linked on ClientID, and show the Project Manager.


Chris Nebinger
 
Actually I forgot to mention that there is a 3rd table
that the data is downloaded to first and then an Append
query is run to move the downloaded data over to the
DataDownload table (There are reasons for this setup that
are too long to discuss and not really relevant to my
problem).

If you're referring to the Project field I have the field
twice because 1) the ProjectClient table is a reference
table that is the end result of 2 other reference tables
combined so that's field 1.
2) The Project field in the DataDownload table is added on
as a way of assigning a Project Manager to their
respective Client. That's field #2
Now the Client field in the DataDownload table is already
loaded with the Client's name. That was already filled in
when the data was downloaded from an Oracle database.
I'm not sure if a simple table merge will do the trick,
but I'll give it a shot.
-----Original Message-----
Why would you have the field twice? (I can think of a
good reason, but I want to hear yours).

You could just use a query to add the two tables together,
linked on ClientID, and show the Project Manager.


Chris Nebinger

-----Original Message-----
Ok here's my dilema,

I have these 2 tables:
tblProjectClient
tblDataDownload

In the ProjectClient table there are 2 fields:
[ProjectMgrPC] & [Client]. Each client is assigned a
Project Manager.

In the DataDownload table there are about 15 fields, but
it also has a [ProjectMgrDD] & [Client] field.

When data is eventually downloaded from our Oracle system
to this Access table, all of the fields will be filled in
except for the [Project] field.
Is there a way (and I'm sure there is), to scan the Client
field of the Datadownload table, cross match the value in
that field against its same value in the Client field of
the ProjectClient table, and then write the [ProjectMgr]
value assigned to that particular client to the
[ProjectMgrDD] field of the DataDownload table?

If so, then how would it be written and where? Should it
be a Module assigned to some sort of triggering mechanism,
attach it to like an On Update or Click expression?

I would appreciate any help on this perplexing task.

Thanks,

Ron
.
Click to expand...
.
Click to expand...
 
Back
Top