Hi, I am a relatively new user of Ms Access. I have 3 drop downs Region - Sub region - Customer The first 2 work fine however the customer drop down seems to reveal the customer who is one way along to the one it should be showing
eg North England
Yorkshire
customer 4 (when it should be showing customer 3)
My sub regions are numbered
then the customers are numbered likewise
ie Yorkshire 4
customer a = 4
customer b = 4
Can someone please tell me where I'm going wrong ?