This database concept is giving me way more trouble than I thought it would, so any help you guys can offer would be most welcome.
Overall concept:
We're creating a database that will allow our sales team to select the options specific to a product they are trying to sell and have the database automatically generate a specifications sheet report.
Specific Points I'm Struggling With:
Some data:
A salesman offers several components within his carwash.
The customer may select whether or not he wants optional components and what specifications he would like for them.
There are other non-optional components that the salesperson needs to specify that are based on the customer's needs.
So the options the salesperson will need in a "New Carwash" form would look something like the following. [X] Means the user wants it, which would unlock the options for that item and, in the end, add the specifications for the checked options to a report with the applicable variables inserted in the paragraph text.
User Options:
[X] Blow Dryers
--Strenth: Option 1, Option 2
--Voltage: Option 1, Option 2, Option 3
[ ] Credit Card Reader
[X] Automatic doors
--Size: Option 1, Option 2, Option 3, Option 4, Option 5
--Color: Option 1, Option 2, Option 3
Carwash Specifications (Non-Optional):
Booster Pump
--Manufacturer: Option 1, Option 2, Option 3
--Voltage: Option 1, Option 2, Option 3, Option 4
--Horsepower: Option 1, Option 2, Option 3
Rinse Pump
--Manufacture Date: Option 1, Option 2
--Voltage: Option 1, Option 2, Option 3, Option 4
--Horsepower: Option 1, Option 2, Option 3
So I imagine at least one of the tables will look something like/be connected somehow like:
Blow Dryers---------------------Strength---------------Option 1
Blow Dryers---------------------Strength---------------Option 2
Blow Dryers---------------------Voltage---------------Option 1
Blow Dryers---------------------Voltage---------------Option 2
Blow Dryers---------------------Voltage---------------Option 3
Automatic doors---------------Size------------------Option 1
Automatic doors---------------Size------------------Option 2
Automatic doors---------------Size------------------Option 3
Automatic doors---------------Size------------------Option 4
Automatic doors---------------Size------------------Option 5
Automatic doors---------------Color-----------------Option 1
Automatic doors---------------Color-----------------Option 2
Automatic doors---------------Color-----------------Option 3
Booster Pump------------------Voltage---------------208v
Booster Pump------------------Voltage---------------280v
Booster Pump------------------Voltage---------------480v
Booster Pump------------------Horsepower----------3
Booster Pump------------------Horsepower----------5
Booster Pump------------------Horsepower----------7.5
Now where to go from here, I have no idea.
I would need to be able to add other components (blow dryers, booster pump, etc), variables (horsepower, voltage) to both new and existing components, and the options for the variables.
It's been awhile since I have worked on a database, so please let me know if I need to explain anything further or provide more information.
Thanks again!!
Overall concept:
We're creating a database that will allow our sales team to select the options specific to a product they are trying to sell and have the database automatically generate a specifications sheet report.
Specific Points I'm Struggling With:
- How to efficiently structure the tables to give the correct selection options
- How to create paragraphs of text that appear based on whether that option is selected or not--and the paragraphs need to contain variables within the text.
Some data:
A salesman offers several components within his carwash.
The customer may select whether or not he wants optional components and what specifications he would like for them.
There are other non-optional components that the salesperson needs to specify that are based on the customer's needs.
So the options the salesperson will need in a "New Carwash" form would look something like the following. [X] Means the user wants it, which would unlock the options for that item and, in the end, add the specifications for the checked options to a report with the applicable variables inserted in the paragraph text.
User Options:
[X] Blow Dryers
--Strenth: Option 1, Option 2
--Voltage: Option 1, Option 2, Option 3
[ ] Credit Card Reader
[X] Automatic doors
--Size: Option 1, Option 2, Option 3, Option 4, Option 5
--Color: Option 1, Option 2, Option 3
Carwash Specifications (Non-Optional):
Booster Pump
--Manufacturer: Option 1, Option 2, Option 3
--Voltage: Option 1, Option 2, Option 3, Option 4
--Horsepower: Option 1, Option 2, Option 3
Rinse Pump
--Manufacture Date: Option 1, Option 2
--Voltage: Option 1, Option 2, Option 3, Option 4
--Horsepower: Option 1, Option 2, Option 3
So I imagine at least one of the tables will look something like/be connected somehow like:
Blow Dryers---------------------Strength---------------Option 1
Blow Dryers---------------------Strength---------------Option 2
Blow Dryers---------------------Voltage---------------Option 1
Blow Dryers---------------------Voltage---------------Option 2
Blow Dryers---------------------Voltage---------------Option 3
Automatic doors---------------Size------------------Option 1
Automatic doors---------------Size------------------Option 2
Automatic doors---------------Size------------------Option 3
Automatic doors---------------Size------------------Option 4
Automatic doors---------------Size------------------Option 5
Automatic doors---------------Color-----------------Option 1
Automatic doors---------------Color-----------------Option 2
Automatic doors---------------Color-----------------Option 3
Booster Pump------------------Voltage---------------208v
Booster Pump------------------Voltage---------------280v
Booster Pump------------------Voltage---------------480v
Booster Pump------------------Horsepower----------3
Booster Pump------------------Horsepower----------5
Booster Pump------------------Horsepower----------7.5
Now where to go from here, I have no idea.
I would need to be able to add other components (blow dryers, booster pump, etc), variables (horsepower, voltage) to both new and existing components, and the options for the variables.
It's been awhile since I have worked on a database, so please let me know if I need to explain anything further or provide more information.
Thanks again!!
Last edited:
