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.
