This is a simple question for most, but it has me pretty confused. A building can have multiple floors, but a floor can only have 1 building. Correct? However, many buildings have a first floor and "first floor" can appear in many buildings. Is tblBuildings to tblFloors a many to many relationship or is it a 1 to many relationship?
Thank you,
Jonathan