Hi Guys,
I am facing an issue with a many to many relation table.
So, here is my table:
Invoice_Id | Check_Id | Supplier Id |
---|
1001 | 1111 | 1 |
1002 | 1111 | 1 |
1003 | 1112 | 3 |
1004 | 1113 | 4 |
1004 | 1114 | 4 |
As, you can see in the above payments table there is a many to many relation between invoice_id and check_id.
There are below three tables and a fact table already loaded.
1. Invoices table: there are many columns in this one, below are two main
AutoNumber (Invoice_Id & supplier_id) as key_id,
Invoice_Id
2. Checks table: there are many columns in this one, below are two main
AutoNumber (Check_Id & supplier_id) as key_id,
Check_Id
3. Supplier table
Supplier Id,
Supplier Name.
4. Facts table: this also has many columns but the main ones are
AutoNumber (SourceId & supplier_id) as key_id, please sourceid column contains both invoice and check id's (they differ as per the type of transaction)
Supplier Id
Now, the issue is the model works fine if I just user 1-4 tables, but as soon as I add the payments table, it goes into a loop and error's out.
I want that when I click on a check, then i should be able to see the invoices for that check and vice a versa for a supplier.
Hope this makes sense. Please help me with this, any help will be greatly appreciated.
Please let me know if you have any more questions.
Thank you