MillerTime
New member
- Local time
- Today, 03:44
- Joined
- Dec 9, 2020
- Messages
- 5
My company sells trailers and we give our customers additional options to add to the trailer before it is purchased (toolbox, mud flaps, ect.).
I have a table set up that would provide information about the trailer (trailer ID, Model ID, make, Year, Vin) and a table for the Model (Model ID, a few kits that will make up the specific model).
I need to have a way to show if the customer put add-ons on the trailer and list each add-on they wanted.
I would think I want that information in the trailer table, but I'm not sure how to handle it if they purchase multiple add on for a single trailer, which would be the case more often than not.
I have a table set up that would provide information about the trailer (trailer ID, Model ID, make, Year, Vin) and a table for the Model (Model ID, a few kits that will make up the specific model).
I need to have a way to show if the customer put add-ons on the trailer and list each add-on they wanted.
I would think I want that information in the trailer table, but I'm not sure how to handle it if they purchase multiple add on for a single trailer, which would be the case more often than not.