Update a table with another tables data

[arey]

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.

 

[Norie]

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.

 

[arey]

thanks but...

if I create a query how do i get the query to update the fields in th enew table?

 

[Norie]

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?

 

[arey]

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

 

[Norie]

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.

 

[cordevil95]

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.

 

[arey]

Thanks the relationship way works pretty good