Hi There,

This seems to be such a simple thing but I can't get it to work even from scratch.

I created a DB with all fields in the same Table, then realised that I was duplicating a lot of data. The database is for recipes, so I initially want to have four tables, one for Reference Books, one for Recipes, one for Ingredient Source and one for Ingredients, ie the quantity, measure used, prep method etc - each ingredient has the potential to be used more than once in a recipe so this is in a portal.

The database works OK as a single table but I'm sure it would work better as four. This is because it generates a new record every time I add an ingredient to a recipe, so even though I have only 70 recipes there are 1400 records! I've tried to create new tables to import the fields into, but the end result is always that the tables are 'Unrelated', even though I've added the relationships.

Can anyone see where I'm going wrong please?

It all makes sense now! I read everywhere that you should enter your data only once, but then read somewhere that you need to have the match fields across tables exactly matching, so I imported the data from one table to the other and voila! It works!