S
Steve
I know I've posted about update queries before, and I did
try replying to the reply of my other post, but it just
doesn't seem to be getting any attention. Therefore, a
new query about my query.
I have 5 tables, each with autonumber primary keys labeled
Patient ID. I am trying to copy data from HospID (a
hospital ID separate from Patient ID) from table A to the
corresponding fields in all the other tables to keep the
user from having to retype the same data 5 times.
I have tried joining the primary key fields in the query,
and putting TableA.HospID in the "update to" field for
each field to be updated. However, I was prompted for a
parameter, which I don't want. I then discovered that you
cannot join autonumber fields in queries, and guessed that
that was why I was being prompted for a parameter. So, I
deleted the "join" lines in the query box, and tried
setting criteria for each field in the form of
TableA.Patient ID = TableB.Patient ID. That didn't work
either. Is there any way I can get this update query to
copy the HospID field from tableA to the other tables
without getting prompted for parameters? BTW, aside from
the autonumber field, the only other unique field is the
HospID field I am trying to update, so joining the HospID
fields in the query box wouldn't work (at least I don't
think so - I may be wrong). I hope I have clearly pointed
out what's happening and what I am trying to do. If you
need more info, check out my other post "Small update
query problem." Thanks in advance.
try replying to the reply of my other post, but it just
doesn't seem to be getting any attention. Therefore, a
new query about my query.
I have 5 tables, each with autonumber primary keys labeled
Patient ID. I am trying to copy data from HospID (a
hospital ID separate from Patient ID) from table A to the
corresponding fields in all the other tables to keep the
user from having to retype the same data 5 times.
I have tried joining the primary key fields in the query,
and putting TableA.HospID in the "update to" field for
each field to be updated. However, I was prompted for a
parameter, which I don't want. I then discovered that you
cannot join autonumber fields in queries, and guessed that
that was why I was being prompted for a parameter. So, I
deleted the "join" lines in the query box, and tried
setting criteria for each field in the form of
TableA.Patient ID = TableB.Patient ID. That didn't work
either. Is there any way I can get this update query to
copy the HospID field from tableA to the other tables
without getting prompted for parameters? BTW, aside from
the autonumber field, the only other unique field is the
HospID field I am trying to update, so joining the HospID
fields in the query box wouldn't work (at least I don't
think so - I may be wrong). I hope I have clearly pointed
out what's happening and what I am trying to do. If you
need more info, check out my other post "Small update
query problem." Thanks in advance.