W
wagwag61
I have several Forms in which I have used the AutoFill feature to populate
some fields based on entries into other fields. (Ex. FormName = GRADES:
Enter EmployeeID and FirstName, LastName, and StudentID are populated:
also
Enter CourseID Number and CourseName, is populated: and Lastly
Enter ClassID Number and Semester, and SemesterYear are populated).
I have set up an UpdateQuery to take the AutoFilled fields and populate the
data to the GRADES table - this works great for FirstName, LastName, and
StudentID. It also works fine for Semester and SemesterYear.
The problem comes with the CourseName field - sometimes the entries into the
Table are correct - but other times CourseNames that correspond to Different
CourseIDs are placed with non-corresponding IDs:
(Ex. HIST403 = Historical Methods, and PHIL220 = Intro to Philosophy - but
when the Update Query runs "Intro to Philosophy" is populated for HIST403,
PHIL220, and two other different CourseIDs.)
Note: CourseID in the GRADES Table is a Text field, CourseID in the GRADES
Form is a Lookup field that pulls the CourseIDs and Course Names from the
COURSES Table. But the same is trues for ClassID and Semester, and
SemesterYear - ClassID in the GRADES Table is a Lookup pulling data from the
CourseOfferings Table - and it works just fine.
Please Help...
some fields based on entries into other fields. (Ex. FormName = GRADES:
Enter EmployeeID and FirstName, LastName, and StudentID are populated:
also
Enter CourseID Number and CourseName, is populated: and Lastly
Enter ClassID Number and Semester, and SemesterYear are populated).
I have set up an UpdateQuery to take the AutoFilled fields and populate the
data to the GRADES table - this works great for FirstName, LastName, and
StudentID. It also works fine for Semester and SemesterYear.
The problem comes with the CourseName field - sometimes the entries into the
Table are correct - but other times CourseNames that correspond to Different
CourseIDs are placed with non-corresponding IDs:
(Ex. HIST403 = Historical Methods, and PHIL220 = Intro to Philosophy - but
when the Update Query runs "Intro to Philosophy" is populated for HIST403,
PHIL220, and two other different CourseIDs.)
Note: CourseID in the GRADES Table is a Text field, CourseID in the GRADES
Form is a Lookup field that pulls the CourseIDs and Course Names from the
COURSES Table. But the same is trues for ClassID and Semester, and
SemesterYear - ClassID in the GRADES Table is a Lookup pulling data from the
CourseOfferings Table - and it works just fine.
Please Help...