I have a a set of tables that relate to each other. The Invidivdual Table relates to the Training Tracking Table via the individual ID. The Training Tracking table is setup to track the cumulative, remaining, rolloever from previous years and prorated (if necessary) hours an individual is required to have for the year. However, what I need to be able to do is keep the historial from the previous years. The problem I'm running in to is that the best way to to do this is to have the relationship with the training tracking table sort by Tracking ID in decending order. This will keep the newest records at the top and so Filemaker will find them first.
But I need to be able to select a drop down and look at previous years. But I can't seem to make that work. I can give screen shots if it will help anyone udnerstand, but I've been struggling with this for a few days and thought I would ask before I cause anymore dents in my forehead.