Add multiple records and diferents quantity

[Biner]

I have a table called “aviamentos”. In this table, I store all the information about an aviamento (name, color, size, and price). I also have another table called “Desenvolvimento”, and one Desenvolvimento can have more than one aviamento.

That’s not the question, though. The issue is: sometimes the same aviamento will be used more than once in the same Desenvolvimento. I need to allow the user to define the quantity of that aviamento needed in each Desenvolvimento.

But how can I do this without changing my “aviamentos” table?

[Kristen]

How do users input their requirements for a Desenvolvimento? Are you using a form?

[Biner]

Its a table component where they use to create a new desenvolvimento.

[Kristen]

Ok - I’m still a little unclear but I think you need another table, for desenvolvimento aviamento’s (please excuse my language I am not sure of the translation).

Add another table with a connection to both, and add a quantity field to that table.

[Biner]

Thanks, Kristen, it worked! I just created a junction table to connect desenvolvimento and aviamento, and in this connection, I also added a quantity field. Now I can define the aviamento, the desenvolvimento, and also the quantity.