hi. i am a small level enterpreneur and trying to develop a database for my business. i have little knowledge of access however not that well verse of technicalities. ok coming to the point i have designed a master table with input of all the purchases i made catagorywise e.g. vegitables, bakery, meat etc however i now want that once i enter purchases in this master table these are also automatically seperated on the basis of catagory and go to their repective tables as well so that i can effectively manage the inventory of each of them. please anyone help me out in this as i dont have that resources to really hire a professional since my business is in early stages...Thanks
naini
- Thread starter naini
- Start date
thanks david for your rep. ok let me try to explain it a bit further. i have created a table in which i enter purchases via form. it contains a dropdown menu to select a particular catagory for each purchase as i already said that e.g. vegs, meat etc. however when i open that master table i am unable to ascertain the exact quantities of each catagory of items i purchased (applying filter is one option but i need a bit more logical and easy way to that). so all i want that each catagory of item entered should have seperate portion eaither through a subtable or something else so that i can ascertain that which item is available upto wht extend and what is left after selling a few of them.i hope this would help you understanding my issue
- Local time
- Today, 17:39
- Joined
- Jan 23, 2006
- Messages
- 15,554
Work through this tutorial and get an appreciation of Normalization and database design.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip
Good luck with your project and your business.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip
Good luck with your project and your business.
David,
purchases are to be used while preparing various dishes therefore these purchases are then to be transferred to work in process module and this is were i am having trouble. sir look, the master purchase table contains all the items and all the catagories so if say 3 out of 5 items are required for a particular receipe then ideally all these items should be available in separate table so that their exact remaining quantity can be ascertained after usage and prior to usage. To be more specific what am trying to make is a store ledger card containing "ins and outs" of inventory and balance quantity as well however i want that i should not be entering items manually to these cards rather just at the time of entering data through main form to master table, these items also get their position in respective specific tables as well.
purchases are to be used while preparing various dishes therefore these purchases are then to be transferred to work in process module and this is were i am having trouble. sir look, the master purchase table contains all the items and all the catagories so if say 3 out of 5 items are required for a particular receipe then ideally all these items should be available in separate table so that their exact remaining quantity can be ascertained after usage and prior to usage. To be more specific what am trying to make is a store ledger card containing "ins and outs" of inventory and balance quantity as well however i want that i should not be entering items manually to these cards rather just at the time of entering data through main form to master table, these items also get their position in respective specific tables as well.
jdraw
just started reading the above referred article and bang...first three lines seems to be the answer to my problem. it is narrated that in last series normalization was done through decomposition by putting all the information in a single table and then separating it into various others. well can you please send me the link to that particular article as well. i would be highly obliged.
just started reading the above referred article and bang...first three lines seems to be the answer to my problem. it is narrated that in last series normalization was done through decomposition by putting all the information in a single table and then separating it into various others. well can you please send me the link to that particular article as well. i would be highly obliged.
it'll be on here..... http://rogersaccessblog.blogspot.co.uk/search/label/*%20Index%20to%20Access%20101%20*
- Local time
- Today, 17:39
- Joined
- Jan 23, 2006
- Messages
- 15,554
These links are referencing Normalization
http://www.rogersaccesslibrary.com/Tutorials/Whatisnormalization.zip
http://www.rogersaccesslibrary.com/Tutorials/NormalForms.zip
They are on the same page as the entity relationship modelling info.
The main page is http://www.rogersaccesslibrary.com/forum/topic238.html
The article on 12 steps to Better Databases,also on that page, is a good reference.
http://www.rogersaccesslibrary.com/Tutorials/Whatisnormalization.zip
http://www.rogersaccesslibrary.com/Tutorials/NormalForms.zip
They are on the same page as the entity relationship modelling info.
The main page is http://www.rogersaccesslibrary.com/forum/topic238.html
The article on 12 steps to Better Databases,also on that page, is a good reference.
