Look up field on form


G

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
 
Ad

Advertisements

J

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top