I have 2 MS Access Tables.

Table 1

id
room-name

Table 2

wall
cupboard
ceiling

Now... table1.room-name has the room names and table2 contains object (many) so each room name contains many objects.

My question is ... How do I set the relationships for this please?