Microsoft Access - SLC Classrooms

Displaying one to one many relationships.

Tables / Buildings

Building ID, Building
1   Blue Wing
2   Grey Wing
3   Tan Wing
4   Yellow Wing
5   Green Wing
6   Orange Wing
7   Energy House
8   Residence
9   Newcourt House
10  Root Cellar

Tables / Floors

Floor ID, Floor
1   Gound Floor
2   First Floor
3   Second Floor
4   Third Floor
5   Fourth Floor

Tables / Rooms

Room ID, Building ID, Floor ID, Room Number, IsClassroom
1   1   1   K02610  True
2   1   1   K02600  True
3   1   1   K02500  True
...
28  2   1   K01210  True
29  2   1   K01200  True
30  2   1   K01195  True
...
38  3   1   K00580  True
39  3   1   K00700  True
40  3   1   K00560  True
...
52  4   1   K00920  True
53  5   1   K00360  True
54  5   1   K00330  True
55  5   1   K00320  True
...

Relationships

Classroom

Reports

Classroom