Recent content by picasso87

Hi Cronk, What is a purpose of having duplicates of ComplianceType table showing on relationship screen?

Thank you all for your help. It is truly awesome and highly appreciated.

Thank you for your advice, I have now revised the schema and this is what i have got. The biggest issue here is that I am forced to use unique identifier of junction table (ComplianceUnitResponsibility) as foreign key in other tables (Inspections and Remedials). Is this an issue? Can this be...

Hi Experts! Hope you will be able to help me? I am building a database to record our responsibility for various compliance types (water, fire and asbestos risk in properties). If we are responsible, we do inspections, otherwise we just keep the data about client units so they appear on report...