Hey Airtable Friends!
I have a problem I can’t solve, but I feel like it has to be doable. I would love some help!
Situation: We’re a mortgage company and we keep a database of our Loan Officers and what states they’re licensed in. Those licenses nee...
When you say customers are you referring to our Loan Officers? If we broke out the licenses into a different table, we would still have to mark in that table which Loan Officer holds that license. If we had 100 Loan Officers licensed in CA we would h...
Thanks so much for your reply!
I looked through the article you linked about the many-to-many relationships, but unless I’m not understanding it correctly, I believe our relationship is actually a one-to-one relationship.
I say that because each loan...
