Hi, I'm a relative FM noob and I have a question on how to design an inventory management relationship.
The inventory is a list of buildings, and each building has a number of office suites in it. Over time, those suites lease, then get re-leased to different tenants. I want to be able to relate the suites to their building, but with some kind of data tracking of the tenant history. IOW, a simple one to many relationship would track suites relative to buildings, but each time you updated tenant info, old tenant data would get lost, and I'm trying to avoid that.