I have been asked to design a system where users can "play" with a recipe of
a product for experimental costings. By play I mean they want to copy the
existing live recipe and adjust inputs and figures e.g. components, labour,
distribution, storage to get an idea of the cost and then if/once they are
happy with it they want to save the new figures. The figures/component
details they want to experiment are stored in a dozen or so tables. What is
the best solution to this problem? I have thought of either making copies
of all the tables, renaming them as tblRecipeComponentsExperimental for
example. or having 2 records for 1 product in each of the tables. Can
anyone offer any advice?
Thanks in advance
|