I have a Table A with an
ID field and a
Question field. The question has a yes/no answer.
I want MS Access to automatically create a new observation (row) in another table, Table B, if I answer yes. How do I do this?
Ideally, I would also like the link between the two tables to be the 'ID' field, which is the primary key of Table A.
This question is vaguely similar, but is not in MS Access.