One-way link between tables

[Mikele di Sagitter]

Hi everybody,



I'm trying to create a one-way relation between two table.
The matter is I'm only able to create such a relation:

Table A and table B.

Changes to Table A are passed on Table B
Changes to Table B are passed on Table A

Otherwise my task is:

Changes to Table A are passed on Table B
Changes to Table B are NOT passed on Table A

So we are free to modify table B, this not will change table A.
I hope I cleary explained my problem.

Thanks

[NTC]

well now...database designers probably would question you with a 'why' on this...because once data is in a db it shouldn't migrate from table to table... be that as it may; you can run an AppendQuery or UpdateQuery (depending on which is appropriate) that will accomplish what you need.