Seeking a Database formula for a Worksheet that will call up a SYMBOL with a RECORD and a PLUG-IN inside the symbol AND report them as a single instance in the DATABASE.
What I'm trying to get is a single instance of the object in the DATABASE where I can put Criteria in columns from both the Record attached to symbol and the Plug-in inside the symbol.
Closest I get is a database reporting both the Plug-in and the Symbol.
Specifics:
I'd like to have a window plug-in as a symbol (W-01) which repeats throughout the project. Want to pull Symbol Record info and Plug-in Info from inside the symbol in the Database row.
The Record attached to the Symbol will contain specific info for each instance of (W-01). IE the North/South/East/West direction, wall type & Sill, Jamb and Head Detail # as they vary for each instance of (W-01).
The Plug-in contains the width, height ect. which i'd like displayed in the same Worksheet.
Ideas ???
- my solution to date is 2 Worksheets, one reporting the record and the other reporting Plug-in inside the symbol. The symbol and plug-in have matching IDs (W-01) which are sorted. The worksheets are overlapped beside each other to create one big Window Schedule.
- Any ideas or alternate solutions people are using would be appreciated!
-Should I give up? Is a window the same size and type but different wall, sill, head and jamb - Simply another window type? - Architectural drafting convention?