auto value throug look up wizard

Hi all

I am an access 2000 user and triying to make a data base for
testing the results wher i am stuck with this problem
In Access , if i put a value in a single cell , the other cell
can pic the other value autmatically

eg

I in a primary table we have two values state and city , in
city coloumn if i enter the city from lookup vizard then it should
always pick up the state automatically from the lookup wizard

Warm regards,
Rajesh

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!