New to Access

[Udayan]

Any body pls help me........

I have two tables called Room Number and Guest List

In Table Room Number five rooms are there called 101,102,103,104 and 105
In Guest List I have Guest name and place

And I have a form like shown below:-

Room Number Name Place
101
102
103
104
105

My question is in the form is there any way to select the guest name by drop
down list and place the name and automatically fill the place column

Please help me.......