K
Kevin
I've been trying to complete an outer join query to base a
subform off of...unsuccessfully. My intent is that I
scroll through Employees on the main form, and to the
EvaluationNumber on the first subform, the second subform
gives me all records from 3 tables which allows me to
enter the New Records when I begin a new evaluation. My
tables are:
"Group"Table
GroupID
GroupDescription
"Category"Table
CategoryID
CategoryDescription
GroupID
"Rating"Table
EmployeeID
EvaluationNumber
CategoryID
Always(number field)
Sometimes(number field)
Never(number field)
I have logical one-to-many relationships for GroupID and
CategoryID fields. I have not been able to achieve query
results that encompass the new records for the Rating
table. I do get ALL records from the Rating tables, but
then the ones with Null value still won't show in the
second subform. Am I going about this the right/wrong way?
subform off of...unsuccessfully. My intent is that I
scroll through Employees on the main form, and to the
EvaluationNumber on the first subform, the second subform
gives me all records from 3 tables which allows me to
enter the New Records when I begin a new evaluation. My
tables are:
"Group"Table
GroupID
GroupDescription
"Category"Table
CategoryID
CategoryDescription
GroupID
"Rating"Table
EmployeeID
EvaluationNumber
CategoryID
Always(number field)
Sometimes(number field)
Never(number field)
I have logical one-to-many relationships for GroupID and
CategoryID fields. I have not been able to achieve query
results that encompass the new records for the Rating
table. I do get ALL records from the Rating tables, but
then the ones with Null value still won't show in the
second subform. Am I going about this the right/wrong way?