How to make a simulation tool

[YellowOnline]

Hello everyone,

I made a big database that links countries, plants, formulas, ingredients and wholesale prices. Currently i have a form showing per formula what plant/country it is from and a subform showing the ingredients and prices. In the main form a total cost is calculated for each formula.

What I need to make is a form that shows the total cost of all the formulas so I can filter by plant (or by anything else). I just don't know how to start because those values are calculated on the fly when viewing a formula.

Second, I also want to be able to increase a certain type of ingredient (they have an associated type label) to see the impact on the costs and compare this to the current costs.

This is really past my Access skills, but my employer really wants me to do this... .

Thanks in advance for your replies/tips/help,

Yellow

 

[YellowOnline]

Too late to edit. Just wanted to say I've read fneily's posts and the databasase is normalised.

 

[MajP]

This should be pretty simple, but I do not think anyone can help without having an idea of your tables and relationship. Please document your tables. This may help to make that easy.
faq700-7905

 

[MajP]

actually Faq700-6905

 

[MajP]

Also, you may want to use a file sharing site to post your db. Just put a small amount of dummy data in it. It may be hard for us to describe how to make this work without seeing a concept of what you are trying to accomplish.

 

[YellowOnline]

Actually, I wanted to do that but Access keeps the file big, even when I removed all of the data :-/ As a zip, however, it is less than 1MB. You can find it with most of the data removed or dummied attached to this post.

Thank you in advance.

 

[MajP]

Make sure you run "Compact and Repair" often. Your DB went from 22m to 512k.

 

[YellowOnline]

OK, NM this thread. It is, in the end, so complex that I hired someone to do help me.