Syncronizing data field from one table field to another table

[Jery J.]

I have two tables, one is used to review cases (Table 1) and another is used
to note needed corrections (such as missing files, etc) to cases that have
been reviewed (Table 2). What i would like to do is to have the general case
information fields (about 5) from Table 1 fill into the same fields located
in (table 2) and then within a form have the cases searchable by the indexed
primary key.

So my question is how can i have specific fields in one table syncronize to
specific fields in another table within the same database?

And how can I make the primary key field searchable where it would show the
case information that is being sync'd?

Thanks in advance for any help!

 

[Clifford Bass]

Hi Jery,

It would be better not to duplicate data from one table into another.
Making sure that the fields are always up-to-date can be a pain and is prone
to error. Then use a query to join the main table and the needed corrections
table when you need the fields from both of the tables. If you do that, you
should be able to search the results of the query by the primary key. Or any
other fields that you want to include from either table.

Clifford Bass