Good Day Everyone,
I am attempting to simplify my life by creating a database for my small business. I run a small Electrical Contracting Business and spend large amounts of time getting information sorted by hand to write up invoices for hours and materials on a project to bill my customers. I have spend the past several days researching and watching some tutorial videos. I feel pretty good about my very BASIC understanding of DB design, but feel that I am at the point where an intermediate or advanced understanding is whats needed.
Any Advice on any aspect would be greatly appreiciated. I am trying to generate an invoice form by project that lists all hours and products used on said project. I am also trying to figure out howto take the retail price associated with a ProductID and show the value from the products table automatically when the item is selected for an invoice.
Thanks in advance for any help,
DBID10T