Look up field on form

[Guest]

After reading about the evils of having a lookup in a table, I removed all.
But now I cannot get the lookup to work in my form. I need to store student
names, school name, course taken, grade received. My tables are linked as
follows:

tblDistrictID tblSchoolID tblCourseTkn
DistrictName SchoolName CrseTknID
DistrictID StdID
SchoolID
CourseName
GradeRcd

The data entry has to be able to add districts and schools on the fly since
people bring in transcripts from across the country. When I make a form
based on tblCourseTkn, it won't allow updates to SchoolID. Any suggestions?
It was way easier (even though wrong) to take care of this in a lookup
table...

Thanks a bunch,
Donna

 

[Jeff Boyce]

Donna

Lookup tables are essential, lookup fields IN tables will cause headaches
("evil" might be a bit strong...<g>).

You haven't said how you are looking up districts and schools on your
form(s). The standard way to do this is via combo boxes. Combo boxes have
a NotInList event and LimitToList property. Checking on these in Access
HELP should give you strong leads to doing what you've described.

Good luck

Jeff Boyce
<Access MVP>