Post by aryetoryn on Apr 6, 2018 7:11:44 GMT -5
Hi,
As the name implies, I have an auto repair shop and I'd like some pointers on how to set up a database for keeping track of customers and their info (names, addresses, numbers, vehicles, etc.), parts purchasing, invoicing, etc. I've learned quite a bit from sheepdog's website regarding the basics of databases, but I'm not sure exactly where to start with my project.
Among other things, here's what I want from an invoice:
I want to input a vehicle's year of manufacture, then I want to select a manufacturer from a dropdown list, then I want a dropdown list containing only those models available in that year, from that manufacturer.
I have lists of both manufacturers and models already.
What I need to know is: do I combine them into one table or would it be wise to have one table for 'make' and one table for 'model' ?
Why go with one table instead of two, or visa-versa?
I'm fairly computer literate, though I'm new to databases.
Any help will be apprecited.
I didn't find the right solution from the Internet.
References:
forum.openoffice.org/en/forum/viewtopic.php?f=13&t=66087
Smart contract technology marketing
Thank you.
As the name implies, I have an auto repair shop and I'd like some pointers on how to set up a database for keeping track of customers and their info (names, addresses, numbers, vehicles, etc.), parts purchasing, invoicing, etc. I've learned quite a bit from sheepdog's website regarding the basics of databases, but I'm not sure exactly where to start with my project.
Among other things, here's what I want from an invoice:
I want to input a vehicle's year of manufacture, then I want to select a manufacturer from a dropdown list, then I want a dropdown list containing only those models available in that year, from that manufacturer.
I have lists of both manufacturers and models already.
What I need to know is: do I combine them into one table or would it be wise to have one table for 'make' and one table for 'model' ?
Why go with one table instead of two, or visa-versa?
I'm fairly computer literate, though I'm new to databases.
Any help will be apprecited.
I didn't find the right solution from the Internet.
References:
forum.openoffice.org/en/forum/viewtopic.php?f=13&t=66087
Smart contract technology marketing
Thank you.