How to add multiple data to linked table?

Question

Database

Please tell me how I can add several details on one form to the second child table. So far, the program works like this: I clicked add. The add form opens. I fill in the information for the main table, select the detail and quantity. But for now, I can only add one. Since the entry in the first one has not yet been created, we do not know the ID and cannot pass it to the child. It is necessary that I enter the main information about the car, then I can add a few parts for replacement, and then I click save and the record is scattered across the tables.

Answer 1

Since you need to add several positions, then you need to create a list for them. We chose a spare part and the quantity, pressed a button, the spare part was added to the list. If the list is not visualized, then add only one button to your form.
And you can prettier, as usual, documents are entered - make a form where there will be a "header" of the document and its "tabular part" - a table in which you will add lines with spare parts. But there is more work here.
The specific implementation depends on how you organize adding records to the database inside the program.

Answer 2

As an option - client data sets. Store information in them, and after, upon receipt of the ID, write