Getting Data from one Table to complete in another
Hi, this is my first time posting, so please be gentle with me! Have been using Access on and off for 20 years, and am now using Office 2016. Quite a few changes since I trained on Windows 98!
I have a database that I use to manage our works mobiles; includes things like user name, mobile number, cost code, sim number, IMEI, etc. This works great for me. I now have another staff member helping out with the issuing of new phones, and I need a simple solution that we both can use for monitoring new requests. I have now set up a "Request" table, which will include staff name and number, request type (smart or basic), cost code, and status of issue (requested, with networking, ready for collection, issued). This means at any given time we should be able to check the progress of a new phone issue. What I would like (if possible) is that when a phone is selected as "issued", the data (staff name, number, Phone details, etc) is automatically added to the main database as an active phone. Most of my column titles match up, but there are some in the Request Table that aren't needed in the main table.
Can this be done? I will add example database for you to see, but will need to anonymise data before I can do this. I'd rather not have to use the lookup column function, as there are over 1,500 records already in the main database!
Thanks in advance.