|
-
Feb 26th, 2007, 02:04 PM
#1
Thread Starter
Addicted Member
[2005] I need advices about Access Database
I am making a stock software which stores informations about wares.
I have a main table which has the stock information (wares, numbers, prices, company etc...)
But software will print a bill if user sells some wares. And software shall save the information form the bill to DB so that user can get informaitons about bill back if needed.
I have 3 ideas:
1) 1 table for all bills: Columns are:
SellNumber / BillNumber / WareType / Price etc...
Each ware which has been sold in the same bill will have same BillNumber but other SellNumbers. So that software can get infos about a specific bill number back.
2) 1 Table for registration of billnumbers and bill infos. And each bill has own table for sold wares list.
3) third idea is like first but different. I want to store data like this
WareType= Pen|Eraser|Notebook|Book and Price= 0.5|0.5|2|5
And if user want to get infos back I can use split function.
I want to ask which one is the best for my access db. There will be a lot of informaitons and I dont want that my db slow down?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|