automatically add record

[Marjo]

I have a database with several tables containing student information.

Table A contains general student information.

What I would like to achieve is that when I add a record in table A, a new record is automatically created in table B with just the student ID no just entered in table A. The other fields in table B will automatically be updated after the student ID is entered.

I hope this makes sense. Can anyone help?

[Ugo DI LUCA]

No it doesn't make sense. As such, it seems like you'd have two copies of Table A, or at least redundancy from Table A to Table B.

There may be occasions where this is needed ( outer joins for example ), but can you be more specific about what exactly Table A and Table B are in real life, so that we may help you out ?