L
lj
I have that provides some information about an item (ItemID is PK).
This form has a subform that tracks when this item is being loaned out and
when it is returned. (ItemID is foreign key).
My question is how to prevent a user from entering a DateOut that is before
the last DateIn?
Subform looks like this (DateOut-DESC so that newest transaction is on the
top):
ItemID PersonID DateOut DateIn
15 141 02/01/2004 <--- how to prevent this typo?
15 107 01/30/2004 02/10/2004
15 123 01/09/2004 01/23/2004
15 115 12/22/2003 12/31/2003
I have data validation set up to prevent the DateIn being before the DateOut
(you can't return something before you checked it out...)
but I can't figure out if it's possible to prevent the new DateOut from
being before the latest DateIn (you can't check out an item that hasn't yet
been returned...)
Any calculation would have to be only on the records for each ItemID, not
the whole tblActivity, which stores the DateOut and DateIn for all ItemIDs.
Any ideas?
lj
This form has a subform that tracks when this item is being loaned out and
when it is returned. (ItemID is foreign key).
My question is how to prevent a user from entering a DateOut that is before
the last DateIn?
Subform looks like this (DateOut-DESC so that newest transaction is on the
top):
ItemID PersonID DateOut DateIn
15 141 02/01/2004 <--- how to prevent this typo?
15 107 01/30/2004 02/10/2004
15 123 01/09/2004 01/23/2004
15 115 12/22/2003 12/31/2003
I have data validation set up to prevent the DateIn being before the DateOut
(you can't return something before you checked it out...)
but I can't figure out if it's possible to prevent the new DateOut from
being before the latest DateIn (you can't check out an item that hasn't yet
been returned...)
Any calculation would have to be only on the records for each ItemID, not
the whole tblActivity, which stores the DateOut and DateIn for all ItemIDs.
Any ideas?
lj