Need Help With Due Dates and Updating Info -- Access

[c0untryB0yFr3sh]

OK.... So here is my project:

I am creating a Database for my mother who manages a self storage facility.
I'm including my table and relationship info... And I may have this all wrong already! Please feel free to beat me up - I am new to Access and I feel like an Idiot!

Here is what I have right now:

1. I Setup a tenant with my New Tenant Form > Save and Open New Lease Form
2. Fill Out New Lease Form > Save and Open New Payment Form

The main problem I am having is with DueDate, PastDueDate and CertifiedDate.

I need the following things:
When a New Tenant > Lease > Payment is Setup I need the

1. DueDate To be 30 days from StartDate (Setup Date)
2. PastDueDate to be 31 Days From StartDate (Setup Date)
3. CertifiedDate to be 45 days from PastDueDate

But PastDueDate Should only be populated if CurrentDate is Greater than DueDate... And CertifiedDate to be populated Only if the Current Date is Greater than 45 days from PastDue Date....

I am trying to set it up so that when a Tenant > Lease > Payment is Past Due or needs a Certified Letter sent it is shown on a daily Report.

Like I said before I could have this all wrong.. I thought of Yes/No Fields for PastDueDate and CertifiedDate But Couldn't figure out how to do that and get the Date that it is Past Due or a Certified Letter needs to be sent out... She needs to see the date as well.

Also if a Tenant Pays their rent on time i Need the Due Date to go to the Next Month with the Same StartDate Day.... And the Same if they are late paying.

Also I need a Late payment Fee of $10 to go on the AmountDue 11 days after the DueDate. I just havent figured out how to factor in Fees...(Do I need a Fee Table? Or put more feilds into the Payment Table.... I'm Lost!!!!!)

I know I am asking a lot and I really do apologize! I'm just trying to get this done for my mom!

Thanks you very much!

Here is my current Tables - Fields & Relationships

Tables (in Bold) | Field Names (Normal) | Relationships (Italic & Color Coded)
Lease ______________Payment ____________PaymentType
LeaseID ______________PaymentID _____________PaymentTypeID
UnitID ________________LeaseID _______________PaymentType
TenantID _____________DueDate
StartDate _____________DatePaid
SecurityDep ___________PastDueDate
LockDep ______________CertifiedDate
Notes ________________PubAucDate
MonthlyAmt ___________ReceiptNumber
Attachments __________PaymentTypeID
AmountPaid
Notes


Tenants__________ Units ___________UnitSize
TenantID __________UnitID _____________UnitSizeID
FirstName _________ UnitSizeID _________ UnitSize
LastName__________ UnitNumber
FullName ___________BuildingNumber
Address Notes
City Attachments
State
ZipCode
Company
Phone1
Phone2
Phone3
Notes
Attachments


Service ____________ServiceProvider _________ ServiceType
ServiceID ____________ServiceProviderID _________ ServiceTypeID
UnitID _______________ServiceProvider ____________ ServiceType
ServiceTypeID ________Address
ServiceProviderID______City
ServiceDate__________ State
Cost ________________ ZipCode
_____________________Email
_____________________BusinessPhone
_____________________MobilePhone
_____________________FaxNumber
_____________________WebPage
_____________________Notes
_____________________Attachments

 

[c0untryB0yFr3sh]

Sorry the Info for the Tables and Relationships is all Jumbled... Here is an Image of what it should have looked like!