Here is my original table relationship:
1.) Accounts have many Contracts
There is a "Bill Date" field within the Related Contract that I'd like to carry over to the Related Account but when editing the table relationship, I can't select a summary field for the Bill Date.
So, I decided to create another table relationship but this time:
2.) Contracts have many Accounts
And I selected "Bill Date" as one of the lookup fields for my Related Account. However, the date is not showing up in the field under the Related Account and I don't know why.
Can someone please advise?