G
gp
I have 2 forms - revisequoteform and lookupquote form with
each with a subform.
I use a link table structure whihc is stored in
quotedata.mdb.
When I open the revisequote form, type in a quotenumber,
it shows all the customer/quote info in main form, and
item details on the subform.
Both lookup quote & revisequote should display the same
info.
Only diff, lookup all fields are locked
In revisequoteform, i can go to subform, doubleclick on
each item and open up a new form to revsie item details.
Right now, for any quotenumber i type in lookup works ok!
but revisequote gives me this error
" The changes you requested to the table were not
successful because they would create duplicate values in
the index, primary key or relationship. Change the data in
the fields or fields that contain duplicate data or remove
the index, or redefine the index..........."
When i type in the quotenumber all the form and subform
get updated, but the subform with the first revision I
made, not the latest one.
The lookup, updates with most latest one!
I would appreciate any input
Thanks in advance
Priya
each with a subform.
I use a link table structure whihc is stored in
quotedata.mdb.
When I open the revisequote form, type in a quotenumber,
it shows all the customer/quote info in main form, and
item details on the subform.
Both lookup quote & revisequote should display the same
info.
Only diff, lookup all fields are locked
In revisequoteform, i can go to subform, doubleclick on
each item and open up a new form to revsie item details.
Right now, for any quotenumber i type in lookup works ok!
but revisequote gives me this error
" The changes you requested to the table were not
successful because they would create duplicate values in
the index, primary key or relationship. Change the data in
the fields or fields that contain duplicate data or remove
the index, or redefine the index..........."
When i type in the quotenumber all the form and subform
get updated, but the subform with the first revision I
made, not the latest one.
The lookup, updates with most latest one!
I would appreciate any input
Thanks in advance
Priya