I like to join two tables. But in the dropdown should be only entries visible with a specific value in the second table.
Example:
Table one
Log List with servername (joined from table two), date, logtext
Table two
List of servers with servername, end of lifetime flag, ...
in the log table join pull down should only the servers without end of lifetime be visible