Hierarchy dependencies problem in Access 2007

P

Peters

Hello,

I am doing my best to create a database of recipies, but have failed,
probably due to my lack of experience and knowledge.

I want to save versions for every recipy (1, 2, 3 ...), and for every
version there will be n steps, and for every step there will be a number of
ingredients. To do this I have done the following charts:

RecipyList
RecipyID
RecipyNo
RecipyName

VersionList
Version ID
RecipyID
VersionNo

StepList
StepID
VersionID
Description

I think this should be 1:N relationships. I have created dependencies from
RecipyList.RecipyID to VersionList.RecipyID
VersionList.VersionID to StepList.VersionID

Using the RecipyList, everything looks right at the start, but when I have
created to version posts and want to continue filling in steps by expanding a
version post by choice, access displays an inputbox and asks for VersionNo
and I do not know why or what I should write. And after that, steps seem to
be associated incorrectly and I do not get it right.

Please help me get the dependencies right (if that is the problem)?!

This should be similar to Customer (Recipy) - Order (Version) - Products
(Steps), so if there is a database you know of that I could modify, that
could perhaps also work.

Thanks in advance,
Peter
 
Top