Inventory Listing by Current Location
Hi, I am stuck again and hopefully someone can help. I have an inventory file. It has three tables: Item, Location, and Picture. There is only one item but the locations change over the years. I want to print a list containing the picture and details about the item with the current location (see screen shot). I have also created fields with:
Last (Location) sorted descending order in the relationship with matching Item ID
Last (Date) sorted descending order in the relationship with matching Item ID
My layout is Item
Find: Shaw Parlor in LastLocationCalc (which is the Last (Location)), and
Find: 3/23/15 in LastDateCalc (which is the Last (Date))
However this doesn't work. It brings in items that used to be in the parlor in 5/16/2000 and now in a new location. In this screen shot, this chair is in a new location.
Any help would really be appreciated.