Multiple Tables, Multiple Filters + Search

[michael.legge@rbc.com]

I am going to try and explain the best way I can, any help would be appreciated. Im tying to create a data base of regualatory document answers that we fill out on a regular basis. This database consists of 2 vendors that both pose different questions (questions are the same everytime- answers vary depending on the situation). Currently I have 2 seperate tables set up using the questions posed by each vendor as the field names. Subsequently each report that we have done and the answers associated are considered 1 reccord.



Here is the challenge, in hopes of having a quick way to fill out further forms we would like to be able to d three things

1) select the vendor (table to look into)
2) select the question of interest (contained in a field)
3) choose the record thats answer would be most appropiate to re-use. Each record has a unique name for the vendors contained under a field.


I have attached a blank layout populated with dummy answers for privacy concers.


I am new to access and I feel i may be in over my head any help would be much appreciated.


Thank you!!!!Example.zip

[June7]

Questionnaire type of database is common topic. Search forum or Google.

Here is one https://www.accessforums.net/forms/q...ase-30753.html