Asset Tracking: Disposals of Stock

[VT]

Hello

I have a fairly conventional demo stock tracking database, where each loan
is handled by a form and subform based on a loan header table and a loan
details table.

How do I handle the situation where a demo unit is kept permanently by the
borrower? I need to remove the demo unit in question but each piece of stock
has many related records in the loan details table, which cannot be deleted.

Many thanks

VT

 

[John Spencer MVP]

Add a NoLongerAvailable field to the table where the unit is recorded. The
field can be a simple yes/no field or it can be a text field where you list
the reason or a date field where you input the date when the unit was lost,
stolen, broken, retired from service, etc.

Now you just check to see if the field is null (or false if you use a yes/no
field) to decide if the unit is available for use.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Fred]

The simplest method would be to put a field in there that says that, and have
your views not show those that are gone permanently.

 

[Steve]

I can't say specifically without seeing the design of your tables. But if
your tables are normalized, you just need to set Cacade Delete in the
relationship and when you delete a demo unit, all related records in the
loan details table will be automatically deleted.

Steve
(e-mail address removed)

 

[VT]

Steve,

I don't want the loan details deleted, I just need to show that an item has
been disposed of but the asset's history must remain.

 

[Steve]

Sorry, I misread your post! John and Fred have the answer for you.

Steve

 

[VT]

Thanks John, Fred and Steve for your help!