Automatically copy data from one field in a table to other related fields in other tables

[Stubbs]

Hi,


I'm trying to create a system where if I enter data into one field it will automatically appear in the corresponding field in another table. For instance if I enter the values 10,12,15 into a field called QID in table A I would like this to appear automatically in a field called QID in table B. Both tables are related and I have enforced referential integrity and 'cascade' options but this still doesn't seem to allow one table to automatically update another. My ultimate aim would be to have a form that you filled in data for the field QID once that then propagated to both Table A and Table B.

Does anyone know how to do this? Is it only possible with a macro and in which case has anyone designed a macro for doing something similar that I could edit?

Thanks for your help!

Jon

[ranman256]

Did you put the 2 tables in a form / subform and match the fields?

[Stubbs]

I can do... I had the table in a form/ sub form before, the problem is if I have one box in my form for data entry as far as I am aware I can still only store this data in one field of one table and this won't copy across to the identical field in the second table.