Hi both, thanks for your replies.
Alan the problem with that is that you cannot assign a unique prefix to the windows of each house, as each house is represented by a symbol. If I give the doors within the symbol the prefix '01', I cannot then duplicate the symbol and have them show as '02', '03' etc... they would all just show as '01'.
Pat, the layers would work, although it is not the ideal solution. My file is made up of layers with associated heights and levels for walls etc... for each storey along the lines of:
L00 - Ground
L01 - First
L02 - Second
L03 - Roof
In the end the solution I found was to put the entry '01' in the field 'User field 1' and to create a report with User field 1 in column A and the formula [=(VALUE(A4))+X] where X is the house number minus 1. (Screenshot attached)
I created a new database for each house stacked within the same worksheet to give me the full schedule. Not pretty, but it'll do. The main problem is the lack of flexibility if I want to manipulate the schedule to show different information, i.e. to sort by door type, as the schedule is broken up into separate databases for each house.
Other things I tried, were putting a space object in the symbol, and calling up the space number with GETSPACENUMFOROBJECT, and then trying to get the space number or name to read from the symbol.
It seems the overriding problem is that it is impossible to call up the individual name of a symbol (as can be manually entered in the data tab of the object info palette) or otherwise refer to the specific symbol instance, both in general, and specifically for an item within that symbol.
This seems to me a fairly obvious functionality given that lots of new build projects are made up of repeated floor plans over multiple floors, but would require a full door / window schedule. Possible wish list item?
Anyway, thanks for your replies, Max