Ok here is a good one, I have done this before in a Filemaker Database but not sure how to do it on wix:
I have a submit form where I input data for every sale in my office, that data is to be stored in a "sales" collection, that input form lets me select the customer through a dropdown referenced to my "costumers" collection, then I need to select the product from the "products" collection, then submit... So far so good... but the question here is: How can I do this but now being able to store more than one product for each sale?
I thought of creating another collection called "items" which serves as a multiple item referenced for the sale and at the same time referenced to the "products" collection. I think i could accomplish this with a button after selecting a product in the dropdown and then adding it to the items collection and showing it on a list.
Any help on how to code this or solve this would be much appreciated.
Thanks in advance