Heres Trouble Posted October 26, 2008 Share Posted October 26, 2008 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? Link to comment Share on other sites More sharing options...
Heres Trouble Posted October 26, 2008 Author Share Posted October 26, 2008 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! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 5802 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now