Relationship between tables issue
I have these tables:
- Annual NOI Ledger
- General Ledger
The Annual NOI ledger appears as a portal on the properties layout.
Whenever a NOI wire is made, it is entered in the general ledger and we'd need to connect it to a property, to do this, I make a record in the Annual NOI portal.
However, the relationship __pkGeneralLedgerID - _fkGeneralLedgerID is not working. even if I use a TO as seen in the screenshot. What am I missing here?