Link tables and auto append fields

[Javed10]

Hi
I have created 4 tables which have 3 field common in all these tables and carry the same data value. Is it possible to enter data in the first tables and it copies to other tables automatically. After all its the same 4 data fields in these tables.
Liver database
Table 1. Auto ID; Surname, First name, Patient ID;-----other not common fields.
Table 2. Auto ID; Surname, First name, Patients ID;----other not common fields.

Thanks

 

[boblarson]

First thing is to say you need to check out and do a search on Normalization. You should NOT be storing the same data in different tables. Why would you have the same data in multiple tables? This makes maintenance a potential nightmare and is just bad design work.

I'm quoting from a post of The_Doc_Man:

Google search "Database Normalization" and look at the .EDU site articles plus any vendor-based articles from vendors you trust. Access also has help on the subject of normalization.

 

[tomlee]

this si a similar problem then i am having i need my tables that haev some common elements to sycronise wioth each other