AnsweredAssumed Answered

How To Pull Most Recent Information

Question asked by sjpockmire on Apr 12, 2015
Latest reply on Apr 13, 2015 by sjpockmire

Title

How To Pull Most Recent Information

Post

I'm working on an inventory program for a house-museum and can't seem to figure out how to make Filemaker pull the most recent information. There is a location table listing where the item is located. As shown, this works fine listing the latest information. However when I run a report like what items are in each room, it pulls an old location. I've tried making the tables the location table but to no help. I've attached a screen shot. As you can see, it needs to pull the information from the most recent inventory. Any help would really be appreciated!

Screen_Shot_2015-04-12_at_12.48.12_PM_copy.jpg

Outcomes