lookup trouble

R

Russ

I have a from with 4 lookups
location, site, etiology, and diagnosis

each lookup is based on the previous lookup. Only site and diagnosis are
bound to a column in the table. location and etiology are not saved.

the problem is that when i am reviewing records and scroll to the next
record, i can not see the value of diagnosis unless the etiology field
happens to be the value that was used when the specific diagnosis was
selected. how do i bypass this problem?
 
Top