recipe file

[GregO]

Hello. Can somebody help me? I'm trying to make a recipe file that calculate the price of a recipe.

I have a table with the ingrediënts and there prices, i want to use. Is there any example-file i can use?

[bcooney]

Too funny. I posted this demo to address a different question. Maybe it'll start you in the right direction.

Recipes.zip

[GregO]

Hello,

Thank you for your quick respons.

can you tell me in witch table i have to import my excisting records with ingredients and prices, ... .

thank you for your help.

[bcooney]

I don't know what format your existing data is in, so I can't say how to import.

This demo took my 15 mins. to do, and is not a "finished" recipe database. You need to finish it.

As for costs, the cost of an ingredient must reflect the qty of the ingredient in the recipe. I haven't addressed that, and just left it user-entered. If you want to lookup costs from the Ingredients file, you'll need to work with units of measure and calculate costs proportionately.

[georgewash]

Can you explain why you need the recipes_recing_Ingredients table occurence? Why can't you simply relate recipes_RecIng:_kF_Ing_ID to Ingredients:_kP_Ing_ID?

15 minutes? I am sick thinking how long I've spent trying to get my portal to work.

Thanks.