I Need To Link Fields In Different Tables

Hi

Can you tell me if the following is possible and if so how to do it.

I have several different tables which require a date to be entered.
99% of the time this date is the same ie
(Table 1) Visit Date = (Table 2) Scan date 1
(Table 1) Visit Date = (Table 3) Scan date 2 etc.....

However in some cases Scan date 1 and/or Scan date 2 may not be the same as Visit date so the input does need to be editable.

Is there anyway I can link the information in Table 1 to automatically be displayed and stored in Table 2/3 and to be able to edit Tables 2/3 if the scan date is different to the visit date which it could be for a small number of records.

Is this possible or is it simply impossible to do this.

Thanks for any advice.