Hello,
first let me introduce myself - I'm Joe and I'm beginner. I'm creating restaurant recipe database.
I have already created one sample but I'm not very happy about that as data flow doesn't look advanced and functional enough.
I want following functionalities for my database:
1) To be able to enter recipe info (name, category, ingredient (1,2,3,4 etc), qty (1,2,3,4, etc), picture.
2) To assign recipes relate to exact restaurant unit and category.
3) To be able to print recipes by one or all recipes relating to restaurant unit or category: name, category, ingredient (1,2,3,4 etc), qty (1,2,3,4, etc), picture
4) To be able to print out a list of recipes referring to exact unit.
I attached my sample of database and wondering how it's possible to amend it to the way provided above. As I'm not advanced user I would appreciate any theoretical suggestions or any practical help to implement functionalities above in to my database or what design of new database should be.
Thanks