473,320 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

recurring and non recurring invoice combined database structure

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
0 990

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

Similar topics

1
by: Maarten Hendrikx | last post by:
Hi, We're planning a web application which will allow teachers to plan their teacher diary online. So for instance: Mondag 8.50 - 9.40 --> Math (First Grade) Mondag 9.40 - 10.30 --> French...
3
by: Bart | last post by:
Hello I am looking for something like visual database structure browser. I need to see all tables and relations beetween them. Something like "Relations" window in Microsoft database products...
0
by: Aleksey | last post by:
Hello, I need to collect some information on changes in database structure for further analysis. I'm interested in the following information: - new and dropped tables and views; - new and...
1
by: Sue | last post by:
Hi again, How can I copy the DB2 database structure alone without copying the data from the tables? I am using DB2 workgroup server versio 8.1. Thanks again!
5
by: Pato Secruza | last post by:
How can I print the database structure, including non default variables like Requiered, FieldSize, and most important DESCRIPTION. I want a table like this: ...
2
by: Arjen | last post by:
Hi, I have some questions about the database structure used by the asp.net 2.0 providers. Why are the tables aspnet_users and aspnet_membership not one table? Why is the userId of type...
1
by: Xerxes | last post by:
Hi, is there a way of exporting database structure not the data in it? Thanks.
1
by: hafizfarooq | last post by:
Hello all, I want to retrieve the SQL SERVER database structure to edit Data type or Field name etc. Please help me
2
by: lihard | last post by:
Hi, I would like to know if there are laws in any state that prohibits anyone from using someone else's database structure and stored procedures. I would like to think that if someone's else got...
2
by: LeXave | last post by:
Hi all I've got the following problem in my database structure : I have a table "User". Each user can have one or more friends which are users too. And I have no idea about the way I must think...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.