T
tim.link
I maintain an equipment inventory database in Access 2003 with just a
handful of tables and several regular queries. Each piece of equipment
has a unique 6-digit asset tag, and that field is the primary key. No
two records can have the same asset tag. Periodically equipment gets
replaced, and I am looking for a way to do the following when
replacing multiple pieces of equipment.
1. Multiple asset tags would be entered into a form or table. Their
corresponding records would be found in TABLE-1
2. Certain fields of the records found would be appended to TABLE-2
showing them as having been replaced
3. The found records would then appear in a table, query, or form
where they could be modified -- (of the twenty total
fields, only four - Make, Model, Asset tag, Serial number - would
be modified with new data)
4. The four modified fields would then be appended to the original
record in TABLE-1 leaving all other fields untouched
I have experimented with Make-Table, Append, and Delete queries as
well as with macros. But, I do not know enough to make this all happen
the way I want it to happen. I have also entered criteria that will
prompt me for the asset tag field in a record. But, this only allows
me to enter one record at a time - which would be okay if there is no
way to do this with multiple records simultaneously. Any help would be
greatly appreciated.
handful of tables and several regular queries. Each piece of equipment
has a unique 6-digit asset tag, and that field is the primary key. No
two records can have the same asset tag. Periodically equipment gets
replaced, and I am looking for a way to do the following when
replacing multiple pieces of equipment.
1. Multiple asset tags would be entered into a form or table. Their
corresponding records would be found in TABLE-1
2. Certain fields of the records found would be appended to TABLE-2
showing them as having been replaced
3. The found records would then appear in a table, query, or form
where they could be modified -- (of the twenty total
fields, only four - Make, Model, Asset tag, Serial number - would
be modified with new data)
4. The four modified fields would then be appended to the original
record in TABLE-1 leaving all other fields untouched
I have experimented with Make-Table, Append, and Delete queries as
well as with macros. But, I do not know enough to make this all happen
the way I want it to happen. I have also entered criteria that will
prompt me for the asset tag field in a record. But, this only allows
me to enter one record at a time - which would be okay if there is no
way to do this with multiple records simultaneously. Any help would be
greatly appreciated.