Subform keeps advancing Master ID number in subform

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have a main form that has a field called "GestioneID" this field is a
primary key and a autonumber.

I have a subform that is in datasheet view that adds items from a dropdown
list to the table "GestioneOrdineMisto"

I have a field [GestioneID] in the subform and the subform is the child of
the main form with the field [GestioneID] as the link.

The first product comes in fine,GestioneID = 9 but when I add another
product, the [GestioneID] field advances to GestioneID=10 and since the
GestioneID is a primary key, it will not allow another entry.

I need to print the form using the GestioneID or something that is unique to
this entry.
thanks for any help
michael
 
I think the problem may be in the fact that the form and the subform use the
same table? The main form has the GestioneID on top and I need to use the
subform in datasheet view so the user can just keep adding more products to
the list. I want each item in the list to be tied to the GestioneID in the
record in the main form.
michael
 
Back
Top