Need help with Validation Rules

[Artful Dodger]

Hello there,
I am trying to set up a database to store financial data.
I have a table Instrument with fields:
Symbol, Bumdle, ISIN, Ticker, Industry Sector, etc.
And a table to store the dividend schedule called Div_Schedule with fields:
Symbol1, Conv_Ex_Div1, Payment_Div1, etc.
I want whenever I insert a value into the Symbol field (Instrument table) the same value to appear in the Symbol1 field (Div_Schedule table).
How do I achieve this?

Thank you for your help.

 

[Artful Dodger]

Forgot to state that I am using Access 2002.
Thank you.

 

[Artful Dodger]

I have found out how to do it guys. Ignore this post.
Thank you.