How can I get data from others tablets on a layout?
I'm noob at FileMaker. Some days ago I developed my first FileMaker case contained in a pdf file for beginners like me titled "FileMaker Training Series: Basics" (link). In that file you can get a first sight about FileMaker basics. Now I'm developing a self-case but I'm stuck.
My database has three tables:
- Flats (Primary key: Flat ID, Foreign Key: none)
- Owners (P.K.: Owner ID, F.K.: Flat ID)
- Tenants (P.K.: Tenant ID, F.K.: Flat ID)
Every table has some Records already and a layout. And the tables have their relations established:
- A Flat belongs to one Owner.
- An Owner may own one or many Flats.
- A Tenant may rent one Flat.
Any Record hasn't been assigned to any other one yet. At the moment any Record belongs, owns or rents anything.
Here is where I'm stuck:
I have designed a layout for the Flats. The layout, named "Flats Details", contains a form which user can fill it with all the information related to one Flat. What I want to do is (1) to add a Drop-down list field on the form where user can find all Tenants names (a field ) and select one. Once user has selected one, (2) I want to add another fields which display automatically some information from that Tenant like his email, phone number, etc.
Well, being in Layout mode with this form, I said to the Field Picker to show me Tenant fields. After that I added to the form a drop-down list field for Tenants name. I created a new values list with all Tenants names, etc. But when I exit of Layout mode, this drop-down list doesn't display any name and I don't know why. Also I don't know how to do my second goal.
I don't want no one gives me a solution just some indications. I don't know how to solve this yet and I spent a lot of hours searching for something but I don't know what search already. Should I implement a script? or should I create a Calculation? Is anything I'm doing wrong? Can anyone tell me about another threat that maybe help me?