1 of 1 people found this helpful
Hi, welcome to technet!
1. Yes, this is possible via a few methods. Method one would be to make your relationship to the portal display table based on a global field in the relationship that changes based on a drop down menu. The other method would be to cartesian join the two tables, and use the portal filtering feature to filter the portal rows on a calculation based on the drop down menu.
2. This is possible using the virtual listing technique, but it might be complicated to wrap your head around if you're just getting started. If you;re interested, MightyData had a blog post about this technique:
Thanks for the help
With kind regards