Update a table with another tables data

arey

Board Regular
Joined
Feb 14, 2006
Messages
166
Hello all,

I have what I call a "main table". It contains a lot of information that I created reports, queries, etc. from.

Now I've come to a point at which I need to create another table but want some fields in my second table to match what is in my "main table".
I need my second table to be automatically updated when ever data is entered into my main table.

Any ideas?

Thank you in advance,
T.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Yes, don't create another table.:)

As far as I can see it's not needed, you could achieve what you want using a query, and that would be updated automatically.

If you created a new table you'd have to manually update it every time you changed data in the main table.
 
Upvote 0
thanks but...

if I create a query how do i get the query to update the fields in th enew table?
 
Upvote 0
What I'm saying is don't create a new table.:)

I don't see why you need to.

Perhaps you could explain further exactly what you want to do?
 
Upvote 0
My main table (Incident table) contains data pertaining to all on-line incidents. I now need to create another table (Incident tracking) to track the work/progression done for each on-line incident.

Both table will have about 3 to 4 columns that will have the same exact data. For instance both will contain Date of incident, Time of Incident, Description of incident. But the second table will contain will contain other fields that will have to be maunually updated.

The tables look something like this...

Incident table:
date of incident
time of incident
application
impact
subject
description
root cause

New table will contain:
date of incident
time of incident
subject
Help desk ticket #
HD status
Follow-up status
follow-up owner
estimated completion date
completeion date
 
Upvote 0
You do not need to repeat the data in both tables.

In the incident table you should add a primark key, say an Autonumber field called IncidentID.

Then add a foreign key field in the second table to that links to the IncidentID.

You can then use this relationship in queries/forms/reports.
 
Upvote 0
Whynot just add the new fields to the existing tables? If for some reason you are being forced to create a new table, then try the following:

Do you have an Incident ID?? Or what is your primary key in each table? If your primary key in "Incedent Table" is IncidentID then just create a field in your "New Table" called IncidentID. Open the Table Relationships and creat a relationship between the tables with the IncidentID field and click Enforce Referential Integrity. Then just create a query that shows the records where IncidentID is equal in both tables.
 
Upvote 0

Forum statistics

Threads
1,213,554
Messages
6,114,280
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top