A little relationship advice...
The attached is a screenshot of a simplified version of a database I am working on.
The database is designed to carry out an audit. The user will utilise the test table and answer yes or no to a series of fixed predetermined questions.
The questions are currently in the "Inspection Items Table" and there are several thousand questions. The 'items' are catergorised using the sections table . All questions are required, sorted by section and item number and will be used for every test.
Please can you advise me how to connect my test and items tables please?