This pertains to an inventory database I am presently working on.
I have items moving to various locations very often. I update their movement in the database, which promptly reflets the same.
Unfortunately, I have one draw back, when I view the report for a particular item, I tend to get a resultant history of the item’s movements since its purchase/ acquisition.
How can I create a report, so that I can only get the most current record which shows its present location rather than getting a complete history of its movement.
