selection from table

[turusov]

Dear FileMaker professionals.

I have a question regarding selection one field from a table depending on another field.

 

I have a layout like this:

 

|Room # |v|         |Name      |v|       |BUTTON|

 

It is the entrance form. So i entering a room# and name. All data goes to my table.

So in my table i have two fileds: 1)Room number 2)Name of person

i would like to use the same layout for choosing person linked to a room number.

If i choose Room number 2, in the next field (with drop down menu) i can choose persons who live in this room#2.

And next to the second field i have a button that opens a layout with person's details.

 

Do i need to write a script? If yes, what script do i have to write?

 

Thank you.