Greetings,
It's been years since I did anything 'technical' in Access and now I'm trying to help out our Service Desk folks by updating their Access Database. I moved all the 'data' into an SQL database. I have 4 databases for 4 different functions. The entire group of databases makes up for the equipment sign-in/sign-out database.
DB-1 = Customer_Sign_IN
DB-2 = Customer_Sign_OUT
DB-3 = Switch_Sign_IN
DB-4 = Switch_Sign_OUT
In DB-1 and DB-2 there are fields that are identical. The common field between them will always be "Ticket #". A customer comes in and filled out the SIGN IN with all the required data. That data is now stored in that database. When the customer returns to pickup their equipment, they go to the SIGN OUT form and fill in the data.
My issue is this.... I have made the "Ticket #" field a DROP DOWN that pulls from DB-1. I would like for the action of selecting your ticket number from that drop down to auto-populate the other fields in the "SIGN OUT" form using the data that was input into the "SIGN IN" form.
I've read quite a few posts on this, but honestly none of it makes sense to me right now. It could be that I've been zoned into this thing for the past 8 hours and now my brain is fried.
I would greatly appreciate any assistance anyone can provide. I know it will be a query, but damned if I can figure out how to get the rest of the query to work.
Thanks in advance,
Carl
Kandahar, Afghanistan