Jump to content

just can't figure out how to do it.


This topic is 5736 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a solution to keep track of rental properties and can’t quite think through the logic of how to handle something. Let me give you an example of a building with 10 apartments and they are all rented.

A. Current tenant moving out: Tenant tells me April 1st… they are moving out of their apartment #412 at the end of their lease on June 1st.

B. New Tenant moving in: On May 12th I have a new tenant who will be moving into apartment #412 effective June 8th. (7 days are needed for apartment cleanup, painting, repair etc.)

Here’s what I can’t seem to get my brain around.

I don’t want to lose all of the past information from tenant A. But I need to add the new tenant on June 6th and start them with their own information.

How would you handle this? And if your idea juices are flowing here’s another related question. How would you put letter B’s name into the system prior to move in? They fill out an application and put down money to hold the apartment right. I don’t just want to put their name on a piece of paper I want it in the database in a way that works.

I use FMP8.

Thanks a lot,


Link to comment
Share on other sites

Hi Bill,

I would use three tables for this. Apartments, Leases, and Tenants. Each apartment would have multiple leases overall (leases would have a ApartmentID field to link them to apartments by relationship, and a Tenant ID field to link to Tenants by relationship), but only one lease for a given period. When you entered the information would be irrelevant - you could just capture this as a 'Lease created on' date field in addition to a lease start date field. You probably could do without a tenant file and just trap that info on a lease, but you would be duplicating that data everytime a tenant renewed a lease, or moved to a different apartment in the same complex.


Edited by Guest
Link to comment
Share on other sites

This topic is 5736 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.