I have a bit of a dilemma in making a cohesive finish schedule...
This is my setup:
I have multiple floor plans - each plan is in a separate file (File A, B, C...)
I have space tags on each floor plan that includes room names, square footages, etc.
I have further attached a custom Record to SOME space tags. This record has information about the finishes in those rooms.
(yes, I do realize that the Space tag has room finish information in it, but the options were limited, so I decided to make my own record for the finishes alone)
My goal:
I need to create a cohesive finish schedule that pulls information from all of my separate files into ONE schedule in a completely separate file (let's call this File X). I also need to be able to edit this worksheet (ie: I need it to update both ways)
Here is the problem:
If I simply create a worksheet in File X that references all my floor plan files, I can get a cohesive schedule, BUT I will not be able to edit it.
So I found another way. I created a finish schedule in each floor plan file. This will give me the flexibility to change finishes directly from my schedule in each file. All I have to do is update the worksheet on File X to reflect changes.
I then created the same finish worksheet in File X. And I edited the database criteria to include information from Referenced files. Using this method, I can successfully create a cohesive worksheet that shows ALL my space tags from all files. However, I only want it to list the space tags that have my custom Record attached. This is where it fails - if I edit the criteria to show items with that Record only, it doesn't find any matches. The same criteria works fine in the individual floor plan files, so I know the information is there. I have imported the Record into File X. So what am I doing wrong? (see screen shots)