multiple identical table and field properties

[chaingangextreme]

Hi all,

I have a project called bariatic surgery effect on weight. And I have 5 identical tables
1.BariaticEffectOnWeight_baseline
2.BariaticEffectOnWeight_6months
3.BariaticEffectOnWeight_12months
4.BariaticEffectOnWeight_36months
5.BariaticEffectOnWeight_60months

and I have these fields;
1. Date
2. study No.
3. MRN
4. Date of Surgery
5. Sex
6. Date of Birth
7. Type of Surgery
8. Indication of Surgery

my question is; the data that I had entered from the baseline with these 8 fields should appear alsofrom 6 months-60 months. I mean when the data entry entered data from baseline it will be part also of 6 months - 60 months as they are the same table. however to make easy in the part of the data entry he will then start key in after the field of Indication of Surgery. Is it part of relationship? Or Am I wrong with field properties? I am newbie here and I will be very glad if you could help me on this...I attached the table for reference and revision..

Please i will appreciate your quick response.

Thanks,

Chain

[chaingangextreme]

I forgot to mention that I have the first field for each table called Sn_No set as autonumber and its my primary key. so it would be 9 fields from the baseline to be shown also through the rest of the table.

Thanks.

[Maqbool]

Thread moved