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