Hi, I hope someone will be able to help me
with
this. Thank you in advance.
I have a cooking database.
Table1 contains recipe code and name
Table2 contains recipe version and reason for
change to new version
Table3 contains recipe ingredients,amounts
and
cooking steps.
I have a form for Table1 which contains
subform
sfTable2 which contains (at the same time)
subform sfTable3. So when you select a recipe
in main form, sfTable2 shows you all recipe
versions, and when you select a version,
sfTable3 shows you ingredients, process
details and amounts; actually this sfTable3
is a table view form.
What I need to do is:
a) prevent recipe composition modification;
b) allow creation of a new version of the
same recipe and, therefore a new list of
components and amounts; from chosen recipe
version
c) avoid MSACCESS to autosave new recipe (new
records) and make it ask me if I want to save
changes or not.
I’ve figure it out I can reach this by
selecting a list of ingredients and amounts
from a specific recipe and version and move
records to a new table, work with them in
this new table and, at the end, if needed or
decided, move new recipe version to TABLE3
(which contains ingrediens and amounts for
each recipe in TABLE1 and each recipe version
in TABLE2).
I guess this must be done using VBA
instructions… or not.
