Help with Relationships

[Gregm66]

Hi All,

I have a form that has 2 comboboxes on it, Combo8 and Combo9.

Combo8 is populated from a table called tblType, based on my selection in combo8, combo9 is the populated from a table called tblRecipes. filtered, so if I choose desert then only the recipes from the category desert are displayed in Combo9.

What I am trying to do is have Combo8 look at other tables also for recipes in different category's.

so if I select Soups in Combo8 then Combo9 populates from a table called tblSoups.



I created a relationship between tblType and tblSoups but it doesn't seem to want to return any values from this table.

Any help on what I am doing wrong would be appreciated.

[ItsMe]

Relationships are defined by adding a column to a table that acts as a Foreign Key. Perhaps your description in post #1 is based on an analogy. Are you really building a solution to keep track of recipes? If so, I do not understand the need for a tblSoups. Instead, I would have a table for Categories or something similar. In this table you could define different catagories of recipes, Soups, Deserts, Entrees, SideDishes, etc. Depending on the purpose and scope, you may have subcategories, too.

[Gregm66]

Thankyou for your reply ItsMe
I wanted individual tables for each category so as to not slow searching down.
But I think I've solved it now I ran the analyze performance and it created what I needed thankyou again for your reply much y appreciated.