OK- this is great! I did the above without an issue and it works great. I can look at my people and see not only who is available, but where each person is currently.
Now, to go another step further. Because different people want to see the information in different ways. I have a table created from my "jobs" table that is my "locations" table. Some of this information was used in the lookup fields for resolving my previous posted question. However, this "locations" table is not related directly to my personnel table or my personnel assignments table. Only back to the jobs table.
When I open this locations table. I hope to be able to set it up to only show me locations with job status that is either active or upcoming, and display the associated job number, anyone assigned to that job number and their job title.
I am thinking that I need to just relate the locations table to the personnel table because now it seems that all the information I need is in the personnel table. However, because this personnel table looked up the location of the person through a separate relationship with personnel assignments I am not sure if it will work.
I always create a separate copy when I am trying things like this, but it ends up taking me a long time of trying to find out that they way I did it is not the best way for future use, or it is not possible and I have wasted to much time on it. Furthermore, I struggle with multiple interruptions constantly causing me to have to backtrack to keep track of exactly where I was and what I was doing next in the creation of these.
