New to Access

[Udayan]

Sir, Any body please 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

Thanks

 

[Wayne-I-M]

Yes you can.

You can add a "dropdown" (Combo box) to your form to show your Guest List.
But you don't say what is a "place". Although it may be tempting to add a
combo to each Room Record ths is not really a good idea as your form would
look very full. There are other methods - you could add just one combo and
fill in the next room or a room that you have clicked or many other things.
You could open a popup showing the Guest List and previous stays in your
hotel so you can see if they liked a room number, etc. etc

There are too mnay options to go into so can you give more details showing
what it is you are trying to do and I am sure someone will be able to help

 

[Udayan]

Thanks for the reply.
"place" is guest's hometown.

Actually my idea was to display all the room numbers in a form.

for example:-

RmNo. Guest Name Place

101 mr.abcd Italy
102 mr.aaaa Japan
103 mr.ccccc India
104 mr.zzzzz France

Guest name can be select through dropdown list. Place comes automatically
with respect to the guest. This guest name and place comes from the guest
table.

For this purpose what should I do?

I already made the following:-

1) room list table.
2) Guest list table with guest name and place/hometown.

How to cook together?

Highly appreciated for your help.
Thanking you in advance

 

[Philip Herlihy]

Thanks for the reply.
"place" is guest's hometown.

Actually my idea was to display all the room numbers in a form.

for example:-

RmNo. Guest Name Place

101 mr.abcd Italy
102 mr.aaaa Japan
103 mr.ccccc India
104 mr.zzzzz France

Guest name can be select through dropdown list. Place comes automatically
with respect to the guest. This guest name and place comes from the guest
table.

For this purpose what should I do?

I already made the following:-

1) room list table.
2) Guest list table with guest name and place/hometown.

How to cook together?

Highly appreciated for your help.
Thanking you in advance

There's a bit more complexity in this sort of situation that many people
spot right off. If these rooms were graves, then the allocation could
be considered permanent, and you could include the ID of one record type
in another (either way). But with hotel rooms, many people will stay
there and some guests may stay several times, in various rooms.

A common solution is to have an "associative" table which you might call
"Visits". For any visit, you'd need the ID of a room, the ID of a
guest, arrival date, departure date, and how much you billed them for
driving the truck into the pool that time. You can build a form based
on a query that joins all three tables; it helps if you establish
relationships in Access first.

In a real hotel situation I guess you'd register (or look up) the guest
first, then select a room using a combo on your form, restricting the
choice to vacant rooms. Or maybe you'd want to check if there are any
rooms free first before registering the guest! You can set the "Row
Source" of a combo box to be a query which selects rooms where there is
no arrival date without a corresponding departure date which is earlier
than now.

Phil, London

 

[Udayan]

Mr.Philip,

Thanks a lot

There's a bit more complexity in this sort of situation that many people
spot right off. If these rooms were graves, then the allocation could
be considered permanent, and you could include the ID of one record type
in another (either way). But with hotel rooms, many people will stay
there and some guests may stay several times, in various rooms.

A common solution is to have an "associative" table which you might call
"Visits". For any visit, you'd need the ID of a room, the ID of a
guest, arrival date, departure date, and how much you billed them for
driving the truck into the pool that time. You can build a form based
on a query that joins all three tables; it helps if you establish
relationships in Access first.

In a real hotel situation I guess you'd register (or look up) the guest
first, then select a room using a combo on your form, restricting the
choice to vacant rooms. Or maybe you'd want to check if there are any
rooms free first before registering the guest! You can set the "Row
Source" of a combo box to be a query which selects rooms where there is
no arrival date without a corresponding departure date which is earlier
than now.

Phil, London