Let's create an Invoice table and link it to the Products table in a many to many (M:N) relationship.
In this case, one Invoice can contain many Products, and one Product can be added in many Invoices
https://ninox.com/en
Support: https://ninox.com/en/support
Ninox Documentation: https://docs.ninox.com/en
Create Invoice table 0:10
Create Product table 0:42
Create MN relationship 1:52
Enrich MN relationship 3:31
Adjust Form and Table view 4:44
Data model 6:14