naini

naini

New member
Local time
Today, 14:18
Joined
Nov 19, 2013
Messages
4
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
 
You need to look into database normalization first. Splitting your purchases into various tables is NOT the answer. Categorizing them is (probably, we need more specifics).
 
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
 
You just need to make a Totals Query (sigma, top right side of Query Design). Group By your category, Sum your inventory field.

How are you tracking sales vs. purchases?
 
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom