I’m trying to create an invoice table, and my problem here is that i can only add 1 product for every 1 invoice. Any suggestions?
Sounds a bir vague. Can you clarify more? Table schema, column structure, how data is related?? 1-2 screenshots could be supportive.
here are 2 screenshots of my column structures!
Why do you need 2 ref columns in Invoice table? Only 1 reverse reference (where isPartOf set to ON) will be enough where you can assign multiple products to an invoice item.
Thank you very much! I didn’t understand the logic of how it works, I just assumed that I needed the 2 columns, cause I wanted to show both columns in my invoice! I’ll try the solution!