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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.