Auto update fields

[jk12]

Could someone please shed some light on any methods on a way to update fields automatically in different tables but with the same field name when data is entered into one of the fields in any table?

Thanks

 

[RV]

If your intention is to store the same data in multiple tables, don't.
You'll end up having redundancy.

RV

 

[jk12]

The reason for repeating the data is that I have one unique number but have many fields associated with it (rather then one unique field with different data) that are requested to be in seperate tables. Therefore I need to show this unique number in each table otherwise people won't know which record they are adding info to or updating. The number also needs to be shown as each table is required to be made into an individual report showing the number.

eg Number (Unique) Field 1 Field 2 Field 3
1 abc def ghi
2 xyz jkl mno

 

[RV]

The reason for repeating the data is that I have one unique number but have many fields associated with it (rather then one unique field with different data) that are requested to be in seperate tables

That is not a valid reason, a proper database structure would only require you to use one table.

The number also needs to be shown as each table is required to be made into an individual report showing the number.

You can filter your report, so you only need one report.
I strongly suggest you reconsider your database structure as it appears it's not normalised.
Which will sooner or later cause you severe headaches

RV