Who Had It - Who Had Item on Specific Date in Microsoft Access, Part 2


	Back to Who Had Item 2 Comments List

Upload Images Link Email

Who Had It

David Semon

12 months ago

What if the rental store has several of each item that it rents? Three hand phasers, 2 transponders, etc.. What changes would be necessary to the function to show which customer had which items?

	Richard Rost 12 months ago
This tutorial assumes that each product is a specific item. If you have multiple items, then you'll have to apply the same technique to an ItemT table which tracks specific items, perhaps by serial number.

	Richard Rost 12 months ago
Access Developer 23

	Jeffrey Kraft 12 months ago
David's Question is basically the question I was going to ask during part 1. And it's the thing I get to tackle at some point regarding a ton of fishing gear I have. I want to track what drawer stuff "might" be in so I don't go to a tackle shop and buy 20 more of the same lure I already have 30+ of.

	Richard Rost 12 months ago
Yeah that's how I am with tools. Can't find my wrench? Go buy another one. Later I find the drawer with 15 of them in it.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Who Had Item 2.