Is there any way to base a filter formula on a lookup field? I have a very simple formula setting the value of text field:
Projects.filter(ID=ID).Project Description.
This works nicely and returns the description from the project table into the description field on my current table. I would like the ID field in the current table to be a lookup field based on the ID field in the Projects table, but this breaks the filter formula. The text in the ID field is concatenated from some other fields - not coming from a static table. I don’t seem to be able to find an elegant solution for this. Any ideas? Thank you!