I have been getting a lot of great feedback from the forums and its been a good response time so I thought id put this issue forwards, maybe its a limitation or maybe i'm  just doing something wrong;

okay so the following is my setup

Regions Form

Region - Single line for each region (Europe, ME, Africa)

Customers Form

Customer Name - Single Line

Region - Lookup field for Region in Regions (Works Fine)

Project Form

Has Lookup Field for Customers Customer Name (Works Fine)

Region - Lookup field for Region in Regions (can bring up the list)

So when creating the project once the user select the customer I want to reference the record of the customer (their Region) and select the region from the lookup field . - this just doesnt seem to work is it because im trying to reference a lookup field?

Is there any way around this or am I doing this a stupid way?

Thanks in advance