Share
Report
2,595Hello,
I have the problem that multiple conditioning is not possible as far as I am aware.
I have a table with some column which got a relationship between each other.
I created single tables to later refer to those with a lookup.
Example: Mainarea, Subarea, City, House, HousePrice
In the Table HousesSold I want to add a form where only belonging items can be selected.
It should only be possible to select Subareas in the related Mainarea and so on.
For two tables that is possible with the Filter option inside forms.
But if I want to now add the field for Houses, I can either chose to filter from Area or Subarea but not both.
That's where the problem occurs as I sometimes will have the case that there are different Mainareas containing a subarea with the same name.
Anyone knows a workaround?
All responses (
Answers (
