OK I was under the impression that I could do all the validation and default values through vb coding with statements like if question id is this and answer id is this then enforce this validation. Maybe it is better just to have all the check-lists as separate tables and do the validation at the table level. I will have to re-think my structure
Thanks for all your help I was worried about misunderstandings of requirements throughout our discussions
The most important thing is that the data entry from a user perspective is rapid with default values and values from last inspection passed to forms and that users cannot enter any wrong information so validation needs to be implemented
It is also very important that forms and queries can get pretty much any information from the tables as well
thanks again