hi

im usually pretty good at access in thw two years that i have been using it but this problem has got me stumped..

i want to use the lookup wizard to allow limited choices but i want these answers to then lead to another lookup field.

example.. for an author first name .. i ahve j.k
how do i do it that when this is chosen that for the author surname instead of having all the surnames that i do have it will be simplified so that only authors' surname with the first name j.k. will show and not the rest....

plz help and explain

thanksss