form to table input

[Joseph_Lee]

Hi everyone, 

i would like to create a single form and select multiple items with different quantity for each item and save to the table as individual row with a single Key number.

Is it possible?

[1minManager]

So you have 2 options here.

1  - Do it all in one form

Wth this your going to need to know advance how many items your going to let then add.  The form will be laid out like this:

[Item 1]

[Quantity 1]

[Item 2]

[Quantity 2]

[Item 3]

[Quantity 3]

...

You then need an action that takes this and writes each item to a subtable as a new row

2 - Use 2 seperate forms

User adds the order/job in a the main table.  Upon saving that you have an actrion that immediately opens another form to add data to the subtable.  Each time they add an item to the subtable and click save, you set it up so that it reopens the same form so they can quickly add multiple items.  To end they simply click cancel

Option 2 is best, but 1 might be easier for you to create.