Our company delivers room for customers. Sometimes clients move to different rooms in the same property. Other times, clients move to another property. We have a Leietaker Master Roster with info like name, current room and current rental price. We also have a Property Master Rooster with the cost of the various rooms on the property. We also have a Leie Master Roster showing rentals per client, per month. What we need now, I will explain with an example:
In the Tenant, we have Jane who started with us in January, and we assigned her to Property # 1
I hope I make it clear. Thank you for your help!