How To Pull Most Recent Information
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!