Hello everyone,
I have the following problem. I want to create a dropdown list that reads values from a form. For simple solutions, this can easily be clicked together. However, now the list needs to be customized. Specifically, it’s about the following:
I have three forms:
1. House
2. Apartment
3. Tenant
In the House form, the other two are displayed as subforms. Here, it works automatically: when I select a house, the corresponding subforms are filtered accordingly.
Now, in the Tenant form, I want to be able to select the apartment that the tenant lives in. For this, I created a dropdown list using the Apartment form. So far, that works — but it shows all records and not just the ones that belong to the selected house.
Therefore, my question is whether there is a way to apply a filter here. It would also be nice if, for the “house-related” dropdown fields, more than one field could be displayed (even if only one can be assigned, of course, multiple fields could still be shown in the selection, especially when pulling from forms).
Kind regards,
Steve
Attachments:
You must be
logged in to view attached files.
Hi Steve,
Your forms are in German so I don’t know which one is which. Although I can guess Haus is the same as House. I did some translating and Mieter is Tenant and Wohnungen is Apartment.
So instead of using a Pick List on your Mieter form, on the Haus form, you can enable the Show Inverse Relationship option on your Mieter relationship. Then on your Mieter form you’ll automatically see which Haus record is related to it.
You’ll probably want a similar relationship between Mieter and Wohnungen.
But I wonder if you actually need separate Haus and Wohnungen forms? Maybe you just need one form with a single field with a Pick List attached to it that lets you specify whether the place is a house or an apartment.
Thanks,
Brendan
Hi Brendan,
Yes the translations are right. I need both, because I do not want just Apartment in the Houses but also Information about the house wich belongs to me. So it is not an Apartment which I own but the house with apartments in it so that is why I need it :)
I already was playing with reversed Relations, but there I get an empty field in the form, The Idea ist to select a house and see which apartments and which Tenants are in it and of course I what to see which tenant has wich Appartment in the house. Or am I thinking to difficult?
Thanks
Steve
.
