SubForm

[Guest]

In my form I have a subform that gets some of it fields filled from the main
form, my "TicketID" in my subform gets filled from the main form as well as
2 others and I'm getting the message that the changes I requested would
create a duplicate value. In my main form "TicketId" is set to NO DUPLICATES,
but my subform is set to YES DUPLICATES OK

My subform is for delays and from time to we will have more than one delay,
when we have only one delay that I fill in the subform fields I DO NOT get
the duplicate message just when I have to enter more than one delay.

 

[Guest]

Never mind I got it, took the Primary Key off of "TicketID", inserted an
autonumbering field and Primary and it now works

THANKS anyway becasue this forum has been a great help in the past.