How you can Connect Lookup Fields?

This link will give you a better idea how you can have a kind of Parent-child relations with two lookup columns. Eg. Country & State

http://blogs.msdn.com/leonidly/archive/2007/06/24/connected-lookup-field.aspx
Connected Lookup Code

Dynamic Connected Lookup for SharePoint