Partially duplicate record on the click of a button.

[CarlettoFed]

Meanwhile, the reports should change as follows:



so you have to create a Cons_Payment table where you register the delivery to which Payment must be related, as you can see below:





moreover you have made mistakes in the structure of the Cons table where for example the FK_BrandID field has the Required property set to Yes but then the data is not inserted.
So, to conclude, you need to create a mask that allows you to select the Cons paid but not yet associated with Paymentsand insert it in Cons_Payment with the relative data.

[bubai]

so you have to create a Cons_Payment table where you register the delivery to which Payment must be related, as you can see below:

So, to conclude, you need to create a mask that allows you to select the Cons paid but not yet associated with Paymentsand insert it in Cons_Payment with the relative data.

How do I place many-to-many table on an input form? Do I have to put the Junction table on a sub-form?
What is the use of putting a primary key on the junction table?

[CarlettoFed]

It is my method to manage the data more simply through a dedicated mask, but it can certainly be removed.