Problem creating a LookUp

[Fekla]

Hello.

I am a newbie in Access. I am making a Boostore database. Here is the
relationship in problem:
http://moryasha.narod.ru/acc.gif

I set the Data Type for BookISBN field in my OrderDetails table to a
LookupWizard. However, I dont want it to look up all the ISBN's in the Books
table, but only those whose Publisher is the same as the publisher of the
relative order.

unfortunately, I am very puzzled and haven't been able to do it by myself.
Can anyone please kindly explain me as detailed as possible? Grateful in
advance.

 

[Fekla]

update

Okay, I worked on the problem all day and it got a bit better. I started using cascading combo boxes and they DO look up the necessary ISBN's... but only for the first order opened!
I guess the problem is that i dont put the ComboBox.Requery command in the correct place.

I put it on the getFocus event of the 2nd ComboBox but it does not work somehow... perhaps I got confused with the logic. Please, do you think you can help me?

In case my explanations are not very clear, I attach the DB.