How to link 2 tables

[smba]

Hello everybody,

I'm trying to find a way to "link" 2 tables in a similar way as Excel... For example, I would want the value in a particular cell of my TABLE1 to change when I change a value in another cell in my TABLE2.

In Excel I can insert a formula in the cell I want to change, Is there something similar in Access?

Regards

[mrmmickle1]

You might try an After Update Macro.

When a record is changed in one table it fires a macro which you could set to evaluate the field in Table2.... i.e. run an Update Query.

[John_G]

No, not really. MS Access not the same as Excel. If you have the two tables joined in a defined rlationship on the two fields, and you have referential integrity enabled, that will work, but the two fileds must have the same value.

I think the only way you can do what you need is through a form, where you can use VBA to update the value in Table2 when you change the value in Table1.