update related tables when changing main table

[virencm]

Hi

I have created tbl_A,tbl_ B & tbl_C. and appended them all to tbl_Main.
I Have staff input info in the main table but this does not change related info in table a, b & c. how do i change this to reflect the changes .
An example would be really helpful.

Cheers !

 

[GinaWhipp]

I'm wondering why you would duplicate data in the other three tables. Kind of defeats the rule of normalized data.

To answer your question... sounds like you are going to have an APPEND or UPDATE query after your User finishes entering data on your form.