I need a database written to store the following information.
1. Term (# of months)
2. Mileage (mileage for vehicles)
3. Vehicle Makes (Example: Ford, Acura, Honda etc)
When writing database tables for Vehicle Makes it divided into 4 different tables.
Each table include different vehicle makes and each table includes its own pricing. Meaning, Table 1 pricing is different from Table 2 pricing.
The objective is to create a simple form whereby the end-user selects from 3 different drop down menus to receive a price quote.
Example Form Details
Select Term (Months)
Select Vehicle Make
Let's say the end-user selects:
Term = 54 months
Mileage = 0 - 60K
Vehicle Make = Acura (Table 1)
The database using the above data would fetch and display the price from Table 1 (See Excel Sheet) of $570
Please review and let me know if you code this. It's a simple database designed to fetch price quotes using the data provided in Excel sheet.