Express to match two tables

[SONCH]

Greetings.
Please can someone help me with an expression that we can use to link two fields in different tables.
That is when you enter data in e.g. field1 in table1 that same data should appear in say field2 in table 2.
Is this possible with access? Just wondering because it is possible with Excel. If possible, please help.

[isladogs]

Yes it's easy enough to do using an update query or a recordset
However why would you want to do so?
Data should only be stored in one place (table) with queries used to get data from more than one table as needed.