jcoe
2007-09-06, 01:14 PM
In an effort to automate schedules as much as possible, I have created our door schedule to reference a key schedule in order to fill out the comments column. When the keynote is applied to the comments column, this in turn updates a schedule that lists the corresponding note. This schedule is then placed below the door schedule on our sheets. However, someone brought something to my attention the other day. The schedule that lists just the notes will only report what has been applied to the comments column in the door schedule via the key schedule.
Basically this means if I have a door that needs to reference Note1, a door that references Note3 and a door that references Note3 and Note2, Note2 will not show up in the schedule notes because there is not a single instance of it on the door schedule even though it shows up in the key schedule. I have tried combinations of filtering and sorting the different schedules, but cannot seem to get a note to list in the schedule notes if it does not exist in the door schedule.
If this makes sense to anybody, I’d love some help. I have attached a sample project with the door and room finish schedules. They both are essentially set up the same way.
Thanks
Basically this means if I have a door that needs to reference Note1, a door that references Note3 and a door that references Note3 and Note2, Note2 will not show up in the schedule notes because there is not a single instance of it on the door schedule even though it shows up in the key schedule. I have tried combinations of filtering and sorting the different schedules, but cannot seem to get a note to list in the schedule notes if it does not exist in the door schedule.
If this makes sense to anybody, I’d love some help. I have attached a sample project with the door and room finish schedules. They both are essentially set up the same way.
Thanks