Questionnaire - Confused and stuck: Part 2

[pdmax]

Hello everyone,



Further to my last post on this matter, I want to develop my query.


I am carrying out a survey with 8 tables and 8 forms. The main form is called "Main Information". The other forms are labelled Part1 - Part 4 (however there are four forms in total for Part 1. Lets call them Part1_a, Part1_b, Part1_c). In "Main information", there is an automated field "App_Id".

"Part1", "Part2", "Part3", and "Part4" also contain this "App_Id" field, and for each record I want this field to be equal to the autogenerated "App_Id" in the "Main Information" form.

Conversely, Part1_a, Part1_b and Part1_c do not contain "App_Id", but rather contain an ID field called "Part1_Id", which is autogenerated in the "Part1" form, and this field should be the same on each Part1 form.

At the moment, each form is separate, and when the "App_Id" field is autogenerated in the "Main Information" form, it is not being updated in subsequent forms. The same problem is occurring with "Part1_Id".

It's unfortunate that I'm using 8 tables, but it's the way I've been asked to complete this task, so any solutions really need to incorporate this fact.

Thank you for reading this through. It really is appreciated immensely!

Best Regards,

Max

[rpeare]

If you're given a project why are they telling you how to design it if you know it's not right. As long as it meets their data requirements why does it matter how you design it. The way you're talking about this you have a FORM > SUBFORM > SUB SUBFORM which is just.... not good.

I'm assuming the information on the sub subforms is only filled out if they respond to the parent item in a certain way.

For instance they fill out Part1_a only if Part1 has a response of 'Yes' for instance.

Without seeing a sample of what you've done so far I can't make any recommendation as to what to do to fix it if you can supply a sample (convert it to 2003 or 2007 please) I can take a look.