Is there anyway sombebody hide the records?

[Guest]

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

 

[Joseph Meehan]

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

Has someone tried a repair and compact. Remember that deleting a file
and its primary key does not really delete it until a compact.

 

[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.