I have a layout with a primary table (audit Protocol) representing text fields for the requirements of an audit. There are additional tables that representing: cross references, questions, remarks, and section comments for the audit linked in a one to many relationship with one being a one to one relationship. The one to one relationship is required, for the company being audited, because there is only one cross reference for each requirement in the primary table.
This layout is fine for a one company layout, but it would be beneficial to introduce a table that lists multiple companies that would be used to select audit questions, cross references, and placement of remarks etc. for each company.
Any help with the relationships would help. The attached relationship graph is what I’m working with.