|
Need a little help. I'm working in Access
97.
I need to be able to populate a field in one table
with information from another table.
I have two relevant tables.
The table names are tblService and
tblServiceInfoResponse. The tables are linked off of the common field
"ServiceKey".
Relevant fields:
tblService - Login, Password, Timebank, Profile,
ServiceKey
tblServiceInfoResponse - ServiceKey,
ServiceInfoCode, Response
I need the field named "Profile" in the tblService
table to be populated with the value from the "Response" field in
tblServiceInfoResponse where the "ServiceKey" is the same and the
"ServiceInfoCode" field has a value of "PROFILE".
Can it be done?.
Timebanking depends upon the "Login", "TimeBank",
and "Profile" fields being in the same table to do its update when it receives
the stop packet, but our accounting package (ISPPower) does not give me the
capability to do this. (ISPPower won't modify or let me modify their
software, and Vircom won't modify the SQL statement to use a criteria other than
"Profile". It would work great if my timebanking sql update said
"where login = "robw" and status = "a"" instead of "where login = "robw" and
profile = "time"
I'm pretty sure it can be done basing the value on
a query, but do I need to do multiple queries to get the information one step at
a time? (A main query with sub-queries)
Any and all help will be GREATLY appreciated.
Robert Smith
Futur@ ISP
|
