Hello AT FamilyTable: Properties (is our base table with all of our info)Table: Mortgagehas all mortgage info pertaining to each property in Properties TableThe main statuses in this table is "Yes, No, Refinancing"Note: some properties in this table ...
We interact with multiple Utility Companies (Water, Electric, Gas from different cities and counties).Is it possible that when I select a Utility company, the contact information auto populates in another field (Separate Single Line Text Fields or a ...
I fixed it. I had to create a formula in the Mortgage TableIF({Status} = "Yes", {Lender}, "")IF({Status} = "Yes", {Loan #}, "")Then I looked up these columns in Properties Table.Finally, I pulled this info into the Insurance Table from the Properties...
See screenshot attached.There are a couple of properties that have an old mortgage, and that status is now NO. So I don't care to see the lender for the NO status. Those few properties now have an active mortgage, and I just want to see the Lender ...
