Hello - I am creating this access database for one of my school's inventory/ equipment checkout.
Each piece of equipment has a unique asset tag on it.
What I am trying to accomplish is for when I assign a user a piece of equipment in the "Laptop Assigned" field in the users table, I want the "Assigned To" information to populate in the equipment table for the piece of equipment that has that asset tag.
Now there are multiple types of equipment that can be assigned to a user (PDA, Laptop, Camera etc) and the equipment table has a "Type" definition for each item.
I had been using a List Box but the problem with that ended up being that it listed out anyone who had any piece of equipment assigned to them, not just the user with that specific asset tag assigned to them.
I have attached an image that lists the 2 tables and the fields in them.
Basically this is what I want to have happen (if possible)...
If in Users
I put an number (asset tag) in the "Laptop Assigned" Field, I want the "Assigned To" field in the Equipment Inventory
Table to populate w/ that Users
"Full Name" as long as Users
"Laptop Assigned" = Equipment Inventory
"Asset Tag" & Equipment Invenoty
"Type" = Laptop
And then the same thing with PDA Assigned, then the type would be PDA etc.
Hope I made this clear enough!
Thanks in advance for any help!