Recipe Database Design Example

You can distribute recipes including through email printed out to index cards or as your printed cook book.

Recipe database design example. When downloading if select reset recipe database the recipe database. Click recipe database editor application to open the editing dialog box. New record button on the design menu click on the button button and draw it out in the form header section.

But looking at actual recipes it needs to be more flexible. After editing click export to save the file to db format. Click import to import db files and edit recipe contents.

Or a table like recipes id likeratio description as text. Arrange them however you wish. The way you usually store this in a database is with an association table between recipe and for example veggies.

To finish this recipe database off open the recipe form f002 recipes into design view. Here s a little structure example. This template can store wide ranging of ingredient information.

A popup box will appear. Now we will add a few buttons that will automate this database. This recipe collection database template is easy to make use and has many tools for simple editing navigation and securing the database.

Theorically you could use a normalized model like the one mike suggested. Recipe recipeveggies veggies recipe and veggies must each have an unique primary key id and the table recipeveggies store both primary keys to create an association between the two.