Hi,
I am getting slightly confused with the relationships in my database. I was hoping someone could point me in the right direction.
First of all, do the relationships look as they should? tbl_loopcheck is the table I use to link all of the data, there is one loop check per tag, and each tag. Each loop check can have one mechanical check, one preliminary check, one function check part a and one function check part b.
Below is the query for the report, which works fine and fills all of the information in as it should (they are some extra tables in this diagram).
I have a form for entering data, with a tab for each section. I will have a button on each tab which will insert the data for the checks.
However, if I need to edit any data, I can't base the form on the same query I use for the report as it is not updateable due to the join types. So I re-designed a query (shown below) which I could base the form on to edit the data. This works, but needs all the relevant data in the tbl_loopcheck fields (Section1ID, Section2ID etc). I can't see an easy way of inserting this information in here.
Could someone give me some general advice on the design of the relationships and the best way to go about inserting data in the forms.
Many thanks in advance for any help.