How to create an invoice table properly?

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.

@LeventK :wink:

2 Likes

https://imgur.com/a/T7G1xCO (table product)
https://imgur.com/a/HZLD7n1 (table invoice)

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.

2 Likes

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!

1 Like