By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,234 Members | 1,877 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,234 IT Pros & Developers. It's quick & easy.

recurring and non recurring invoice combined database structure

P: 1
Hi, I'm currently creating an application which involves selling of products, equipment and service repair, also rentals of equipment. What is the best database design in this application? currently I have tables for Customer, Invoice, InvoiceDetail, ProductList, EquipmentList, WorkOrder. Do I need to have separate invoice table for rentals which is recurring invoice. and also do I need to create 3 separate create invoice form for selling parts, selling equipment and rental of equipment, because of parts lookup or equipment lookup for description. the system should prompt to create invoice every month which specifies covered dates. I'm using VB2010 and MS Access, Thanks so much for any help
Jun 17 '12 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.