How to create an invoice table properly?

[bulgogi94]

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?

[LeventK]

Sounds a bir vague. Can you clarify more? Table schema, column structure, how data is related?? 1-2 screenshots could be supportive.

[Marc_Dillon]

Guide on How To Create a Community Post Tips & Tricks 💡

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

@LeventK

[bulgogi94]

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

here are 2 screenshots of my column structures!

[LeventK · Accepted solution]

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.

[bulgogi94]

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!