Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-12-2019, 12:43 PM   #1
Mrsdeapsleap
Newly Registered User
 
Join Date: Jan 2019
Location: Newport, South Wales, UK
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Mrsdeapsleap is on a distinguished road
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.

Mrsdeapsleap is offline   Reply With Quote
Old 01-12-2019, 01:11 PM   #2
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 13,566
Thanks: 73
Thanked 1,483 Times in 1,372 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Getting Data from one Table to complete in another

If you are both using the same data, you should first consider doing a database "split" so that you are both working on the same tables. Look up the topic "split a database" in this forum for articles on doing it. There is a ribbon option that will do a split for you on the Database Tools part of the ribbon.

When you talk about "main database" and whatever databases you are using (that obviously are NOT the main database) then we need to know how they do (or how you intended for them to) communicate. Are all of the databases simple Access? Or do you have something in SQL? Or are they Excel files? We need to have some idea of the structural constraints before we can advise you how to implement what you request.

This should not be difficult but there are three or four different ways to approach the problem and I think we need to understand the direction from which you are coming.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Search multiple files and copy complete row data. Venkat1067 Excel 0 04-30-2018 04:30 AM
Table help for complete noob forson96 Forms 1 03-29-2017 02:33 AM
Lookup Column not extracting complete data accUser2010 Tables 6 11-04-2010 09:32 AM
Exporting data to excell did'nt shows complete data aamir4a Reports 1 11-07-2007 02:04 AM
Clear data in a complete yes/no column Hartkoorn General 3 08-12-2006 10:39 PM




All times are GMT -8. The time now is 05:12 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World