I have two Item Type definitions: Area Features and Doors. I can tag an office, for example, as an Area Feature; and I can tag a door cell as a Door. Here's an illustration...
Now I want to relate one to the other. You can see that Door 102 belongs to Room 102, but MicroStation cannot deduce that relationship. I'm looking for suggestions on how I might establish what a relational database designer would call a table's foreign key. Door 102 should have something that links it to Room 102. What should that something be?
My goal would be to define a Report that lists, for example, Rooms and the Door(s) that belong to each Room...
While all offices have a single door, the meeting rooms each have two doors.