Thanks Piet. I found a lot of articles and links. This is one of them:
(e-mail address removed)
Lars
<
[email protected]> schreef in bericht
I've found some inventory templates on the internet but none of them have
the option to lend goods and to schedule the lending. Does someone know of
a
template, screenshot example, or datamodel of such a functionality?
Thanks in advance, Lars
Albert Kallal has some notes on it on his website...
see
www.mvps.org/access to find it, or search in this NG.
I did this once a long time ago now. I asked Albert kallal and others
lots of questions, so you should be able to find it. It was about
Summer 1999... The hard part is determining what items are available,
but Albert had some really excellent examples of how to write those
queries.
Mine worked with:
Kits
Items
People
KitReservations
LoanItems (because I broke the Kit into individual Items, because they
contained many pieces that could be lost).