Is there anyway sombebody hide the records?

[Frank Situmorang]

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

 

[Arvin Meyer [MVP]]

If the number was an autonumber and is the primary key, it can never be
re-entered. If you had cascading deletes turned on, you also deleted the
invoice.

Try using the Find Unmatched query wizard to locate your missing records. If
you find them, you may change their Foreign Key to the correct number. Turn
off Cascading deletes, if it is on. To the uninitiated, automatic deletion
is very dangerous.