Form to pull rental records
Posted: Sat Jan 12, 2019 10:02 am
Hello all !!
I am presently creating a database for my plane-leasing business. What I would like is one for that when I type in the customer information it brings upin a little grid pattern, all the planes that person has rented from me and all the details of said lease agreement but I am not sure how to do this.
Would I have to create a separate table that I would manually have to populate with the data?
Heres what I have so far
Customers Table
Customer Number Integer field primary key
Account Number Text VarChar
First Name Text VarChar
Lastname Text VarChar
E-mail Address Text Varchar
Company Text VarChar
Aircraft Table
Stock Number Integer Primary key
Registration Number Text Varchar
Airplane Make Text fix Char
Airplane Model Text fix Char
Engine Type Text VarChar
# of Engines Text VarChar
Airframe Hours Time Time
Engine Hours Time Time
IFR Equipped Boolean
GPS Equipped Boolean
Ap Equipped Boolean
Declared Value Number Numeric
Monthly Charge Number Number
Service Fee Number Numeric
Lease Terms Text Varchar
Lease Start Date Date
Lease ENd Date Date
Leased to text varchar
I would also eventually like to get the payments to come up below that table so that when I look up a customer I see what planes he/she has leased and what payments have been made, but if someone can help me get the planes leased part working I'm pretty sure I can figure out the payments and notes parts of the form.
So just to say again what I want is to type in say:
John Johnson and it will tell me that he is leasing a Learjet 45 from me
the declared value is 560,000.00 with a service fee of 560.00 and a lease payment of 1560.00 a month with a lease start of 10.28.2019 and an end date of blah
This way if a customer calls me and says that he needs information for insurance or so I can pull it up quickly for him and don't have to wade thru table after table of data.
I'm sure that this is prolly done with subforms, but I don't fully understand them and have spent at least 4 hours trying to get them to work to no avail.
So if someone could tell me how to set this up i would greatly appericate it as I have no clue how to do it and have spent way too much time trrying to figure it out. I am thinking I will have to create a table that i manually populate with all the data to be able to acheieve this
I would also like to know how to create a form that i could go in and say change the lease end date on if the terms happen to change or something like that.
Jeff
I am presently creating a database for my plane-leasing business. What I would like is one for that when I type in the customer information it brings upin a little grid pattern, all the planes that person has rented from me and all the details of said lease agreement but I am not sure how to do this.
Would I have to create a separate table that I would manually have to populate with the data?
Heres what I have so far
Customers Table
Customer Number Integer field primary key
Account Number Text VarChar
First Name Text VarChar
Lastname Text VarChar
E-mail Address Text Varchar
Company Text VarChar
Aircraft Table
Stock Number Integer Primary key
Registration Number Text Varchar
Airplane Make Text fix Char
Airplane Model Text fix Char
Engine Type Text VarChar
# of Engines Text VarChar
Airframe Hours Time Time
Engine Hours Time Time
IFR Equipped Boolean
GPS Equipped Boolean
Ap Equipped Boolean
Declared Value Number Numeric
Monthly Charge Number Number
Service Fee Number Numeric
Lease Terms Text Varchar
Lease Start Date Date
Lease ENd Date Date
Leased to text varchar
I would also eventually like to get the payments to come up below that table so that when I look up a customer I see what planes he/she has leased and what payments have been made, but if someone can help me get the planes leased part working I'm pretty sure I can figure out the payments and notes parts of the form.
So just to say again what I want is to type in say:
John Johnson and it will tell me that he is leasing a Learjet 45 from me
the declared value is 560,000.00 with a service fee of 560.00 and a lease payment of 1560.00 a month with a lease start of 10.28.2019 and an end date of blah
This way if a customer calls me and says that he needs information for insurance or so I can pull it up quickly for him and don't have to wade thru table after table of data.
I'm sure that this is prolly done with subforms, but I don't fully understand them and have spent at least 4 hours trying to get them to work to no avail.
So if someone could tell me how to set this up i would greatly appericate it as I have no clue how to do it and have spent way too much time trrying to figure it out. I am thinking I will have to create a table that i manually populate with all the data to be able to acheieve this
I would also like to know how to create a form that i could go in and say change the lease end date on if the terms happen to change or something like that.
Jeff