AnsweredAssumed Answered

Inventory Listing by Current Location

Question asked by sjpockmire on Apr 28, 2015
Latest reply on Apr 29, 2015 by sjpockmire

Title

Inventory Listing by Current Location

Post

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.

Screen_Shot_2015-04-28_at_10.29.37_AM.png

Outcomes