Info from Table A to Table B

[Jaro19a]

I do not know how to do this. I hope some one can help me.

In Table A, I have a ID feild, Name feild, and some other feilds.
When a new record is added in Table A (via a form), I want the ID and Name feilds to be added to Table B also.

Thank you are your help,
Jeremy C.

 

[DBL]

Maybe a bit of an explanation as to why you want to do this would help because if all the data is in Table A then there is no reason for it to be in Table B too, that I can think of.

DBL

 

[ColinEssex]

As an extention to the previous answer (Hi Dawn!)

You would only add it to table B if you are adding records to table B - such as orders or something.

Col