Hello Everyone,
I am hoping for some help automating a task in Access. I have scoured forums and YouTube, but so far, no luck...
In the same database, I have a "Item Distribution" table and a "Item Serial Number" table.
The Item Distribution table includes (among other things):
-A Serial Number field: Pulls values from the other table;
-A Item Returned Date field;
-A Date Updated field
The Item Serial Number table includes (among other things):
-A Serial Number field;
-A Current Location field;
-A Date Updated field.
When a new record is added to the Item Distribution Table, I would like the Item Serial Number Current Location field to change to "Assigned." When a returned date is added to an existing record on the Item Distribution table, I would like the Item Serial Number Current Location to change to "Stock." In both cases, the Item Serial Number Date Updated field should also update.
Is there any way to automate this?
LIMITATIONS:
1. The same Item Serial Number may be listed multiple times on the Item Distribution table, should the same item have been signed out and returned multiple times. I am interested in the most recent change to a record with that serial number.
2. There are additional location possibilities on the Item Serial Number table that would never appear on the Item Distribution table, (such as "Repair Shop" or "Destroyed").
Thank you very much for your time!