Looking and storing values of data of its own

[kadidarm]

Hi
I have just started to make a Bill of Material Program (BOM) for my
self using Microsoft Access 2003. I am looking to make a recipe
database. The problem I am having is this:
I have a table called tblRecipe is linked to tblRawMaerial. In
building my BOM, tblRecipe needs to look up tblRawMaterial as well as
tblRecipe itself because a product of a recipe can also be used to make
another recipe. For example, to make chocolate chip cookies, you need
dough + chocolate chip and to make dough you need eggs + water etc.

One solution I can think of is to make a union query of both
tblRawMaterial and tblRecipe and add a field with both indexes
(RawMaterialID & "." & RecipeID). Then I can store this query index
onto tblRecipe. Is there any better way of doing this?
Any help to optimize this would be greatly appreciated

[Phil Stanton]

Been there, done it. Complicated

Does the recipies and infinite sub recipies. Has also different suppliers of
raw materials. Also batch control Only limitation is that as far as I
remember all recipes are for 10 kilos (or is it 10 tons). Access 2000

Is it for commercial use or private use

HTH

Phil
<ka******@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Hi
I have just started to make a Bill of Material Program (BOM) for my
self using Microsoft Access 2003. I am looking to make a recipe
database. The problem I am having is this:
I have a table called tblRecipe is linked to tblRawMaerial. In
building my BOM, tblRecipe needs to look up tblRawMaterial as well as
tblRecipe itself because a product of a recipe can also be used to make
another recipe. For example, to make chocolate chip cookies, you need
dough + chocolate chip and to make dough you need eggs + water etc.

One solution I can think of is to make a union query of both
tblRawMaterial and tblRecipe and add a field with both indexes
(RawMaterialID & "." & RecipeID). Then I can store this query index
onto tblRecipe. Is there any better way of doing this?
Any help to optimize this would be greatly appreciated

[kris Adidarma]

Hi, this is for my own use. Do you think my method works well? Any
help is appeciated.

[Phil Stanton]

If you want a copy I can send it to you. Might save you a lot of work. I
presume you can download attachments from Hotmail OK.

Phil
"kris Adidarma" <ka******@hotmail.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...

Hi, this is for my own use. Do you think my method works well? Any
help is appeciated.

[kris Adidarma]

If you could be so kind, my email is ka******@hotmail.com. Thanks in
advance.

[kris Adidarma]

I guess they truncate my email address, the hotmail address is
"kadidarm" without the quotation marks.