Reply to Continuous Form
Thank you Pat. I am new at this and have learned a lot since this posting. I have accomplished the first part of my objective by using a subform. I am building an evaluation system using six tables. The questions table works well in combination with the criteria table. The next table is the jobs table then the employee table and then the answer table. When I link the job code table it says The SQL statement could not execute because it contains ambiguous outer joins. To force one of the joins to perform first, create a separate query that performs the first join and then include that query in your sql statement. When I copy the Job code to the questions table all of the tables work in unison. Of course that causes me to have to store perhaps a hundreds times more data. I have a second problem related to display of the data. I would like all of the questions and answers to come together in a subform but let me tackle the first issue first. Can you help?
Thanks for your comment.
Bob (Nashville)
