Display value from recordset

Hi,

This is prob a simple thing and i know i have done this before but for the life of me cant remember.

I have on my page 2 recordsets.

one displays from my table "Clients"

the other from my table "Regions"

in my insert into clients table i chose the Region name as to display when inserting but to use the ID for the value to be inserted.

Now when i view my clients recordset set i see "Region = 80" when it should display "London"

how can i display London instead of the value "80" ??

many thanks