I just created Supplier Invoices tracking database. It works ok, but now my
people said for one particulair supplier he can not see anymore all invoices
that he had input.  Invoicetable is linkied to the supplier table. What I
suspect he did, is because there are 2 suppliers with almost the same name
and invoicess has linkied with these 2 suppliers and he delete 1 supplier
because actually it should be only 1, he did not realized that the invoices
linked to it could be lost if he just delelte this supplier.

My question why if he entered again the lost record, he can not enter it
unless he put different invoice number(plust x at the end). Why is it
rejected, if the invoice number was deleted (primary key is invoice number).
Is the nubmer still remembered by the system?. Pysically we do not see
anymore that invoice number, but why is it still rejected when it is reinput.

Or sombebody can hide it?, I try to export all into excell we can not see it

Frank