Many to Many relationship from three tables

[Anonymous]

Hi all,

I need your help regarding many to many relationship. Here I have 3 tables: Cust_Ledger, Detailed_Cust_Ledger and ValueEntries. I want to get the Collection Date to be shown on ValueEntries table. But the date only can get from Detailed_Cust_Ledger.

Cust_Ledger and Detailed_Cust_Ledger is basically the same, but here has Collection_No column. As you can see many Collection_No can relate to one Document_No and also vice versa.

Is there a way that i can bring the Collection Date to ValueEntries table?

[amitchandak]

@Anonymous , You can take max of collection date along with columns from value entries(if they are un summarised)  and customer ledger

In case on 1-M and 1-M. Only one M can have un summarized column.

[Anonymous]

Hi @amitchandak , thank you for the reply! Could you elaborate more on this? I dont quite understand.