Hello AT Family
Table: Properties (is our base table with all of our info)
The problem I'm having is it's pulling the both lenders with "Yes and No" status.
How do I make it only pull the Yes lenders?
When I filter to show ONLY Yes, it doesn't show anything because the property may have a Yes and No status.
I fixed it.
I had to create a formula in the Mortgage Table
Then I looked up these columns in Properties Table.
Finally, I pulled this info into the Insurance Table from the Properties Table from the Mortgage Table column with the formula I created.