I am a new Access user (although I took a course in Access). I created a Recipe Database - however, I want to run a query listing all the recipes by name only. I have 4 tables (Bread, Ethnic, Pasta, Vegetables. In the query, I add the Recipe Name for each of the items, however, when I run it, I get 2 of the same bread in one column, 2 of the same ethnic recipe name in the 2nd column, etc.. Always 2 of everything. Do i have to join these tables?? and where? The primary key in all is the recipe name.

I would have thought that all your recipes should have been in the same table with a catagory field to specify Ethnic, Pasta, Vegetables, whatever. You are getting the multipe results because you have no relationship between the four tables.

Think about putting all the receipes in the same table and adding the additional "category" field. Create a second table that has the different category names in it, with an autonumber for each, which will be the primary key. In the form where you enter the data on the recipes create a combo box using the wizard, look up the category from your lookup table and assign the category autonumber to the category field in the recipe table

HTH

[This message has been edited by D B Lawson (edited 02-10-2002).]