I got this error "Errors were encountered during the save operation" !!?

[hannoudw]

I got this error "Errors were encountered during the save operation" !!?
and when i click on help i got this:
This error can appear if:
You have exceeded the maximum number of columns allowed in a table or the maximum number of locks for a single file.
The indexed property of a field was changed from Yes (Duplicates OK) to Yes (No Duplicates) when duplicate data is already present in the table.

but i just have 14 columns!!
item(Article,st ock,price,code_ supp,st_q1,st_q 2,...,st_q10)

actually this error occurred when i was trying to put the default value of stock equal this

(st_q1+st_q2+st_q3+st_q4+st_q5+st_q6+st_q7+st_q8+st_q9+st_q10)

can any one help me please!!

[Steven Kogan]

I'll try to help.

Instead of changing the index and default value at the same time, try making those changes separately. Save after each change.

It seems you are trying to change the table design to index Yes (No Duplicates). Are there already too many duplicates? Perhaps that is causing the problem.

To check for duplicates construct a Find Duplicates query with the Query Wizard.

Setting the default value to the sum of other fields is problematic: you may want to consider using a calculated field in a query instead? Otherwise, the initial values of the fields would be zero, and your default value would end up being zero. So setting the default value in the table design doesn't make sense to me...

[hannoudw]

ok thanks a lot
i'll try it
another question do you know this error?
cannot add records; join key of table 'item' not in recordset

[Steven Kogan]

I don't recognize that error message. Is that the complete message?

[hannoudw]

yes steven thx i solve it ...
but still i need help
can you help me ?

[Steven Kogan]

Sure. How can I help you?

[Steven Kogan]

Do you want to remove existing duplicates (for that field) in the table? That would be a good starting point.