I need a guide!!!

[DaniBoy]

Hello
I need to create a small DB for our Apartment Complex. Its basicaly just to keep track of leases and peyments. Here is what the DB need to do.

I need to have Tenants info and Apartment info on the DB, for this I create two different tables, tblTenants and tblApartment. So far I'm doing good. I now need to create a Lease for this DB. On the lease I need to have the information of the following fields:

StartDate
EndDate
PetFee
PetDepot
AptRate
AptDepot

I now need to make a form that will let me choose the Tenant, the Aprtment they are leasing and input the lease information. Here is where I have the problem, when I create the form I want to be able to input all the info in a single form. and be able to create new leases and not get a duplicate error when I make a new lease. How can I do this?

I also need to create some type of monthly payment for each active lease. How would you make something that will create an invoice automaticaly by pressing a button. Meaning that if the user clicks this button there would be a place where they can see what this tenants ows.

Then I would need to have some form where you input paymenyts.

have any ideas on how to beging this DB, I am confused.

Daniel

 

[ReAn]

Ok, this is a rather large task, let me make you a sample db.

Check back in ~15

 

[ReAn]

Take a look at this simple example... i hope it helps.