Hello all,
Thanks in advance for your help.
I am trying to create a database for leases and lease proposals. Here are the tables I am concerned about:
Lease (tenant name, rent, proposal/signed)
Space (Floor, building, office/retail)
Measurement (as of date, measurement 1)
There is a one (lease) to many (space) relationship because a lease may cover many spaces, and a one(space) many (measurement) relationship.
The reason I have a "measurement" table is because suites change sizes, so this allows the user to say 'as of Dec 31, this suite will now be 5,000SF'. Hence the one to many relationship.
Now, the problem is that when I go to create a proposal I want them to be able to include a new measurement. However, if the proposal doesn't go through or there are multiple proposals, I don't want the measurement to apply.
So, why not just make the measurement related to the lease? Because if the space is vacant, there will be no lease, and so it will 'disappear'.
Any suggestions on how to handle this would be greatly appreciated.
Thanks,
Mick