lookup calculation question

[ballkc]

I am working in a hospital where patients are in rooms and rooms are on named floors.

i would like to be able to enter a room number for a patient and have the database lookup or calculate the floor name.

it seems easy but im stumped.

i have a table for floor names with beg and end room numbers related to the patient information via room number which is related as beg = room number = end.

please help

ken

[comment]

If the relationship is set up correctly, you can place the floor name field from Floors table on the patients layout (make it non-enterable, so they cannot modify it accidentally). No lookup or calculation is required.

[ballkc]

thanks to all

i re-examined the relationship and had it backwards. works like a charm now.