form where multiple products and quantities

[Gustavo_Eduardo]

Hi everyone, I'm trying to build an application where I charge sales. Sales carry various products and associated quantities.

Does anyone know a way to make a form where multiple products and quantities can be uploaded?

For example:
Bread x 10U
Cakes x 5U
Donuts x 15U

That is, a drop-down list that is generated after another, with an associated quantity. I appreciate your answers.

[TeeSee1 · Accepted solution]

Isn't this a typical use case of  "Is APartOf" referential architecture?

[TeeSee1 · Accepted solution]

Isn't this a typical use case of  "Is APartOf" referential architecture?

[Marc_Dillon · Accepted solution]

You don't. You add another child table.

[Gustavo_Eduardo]

I did it like this, a child table and I made the parent record part of this table. I had no choice, but it is comfortable anyway.

Thank you for your answers.