I've recently started working on a database that was started by someone else but never finished so i'm trying to finish it.

The database has one to many relationships and i am trying to setup a filtered portal based on a field and am having a little bit of difficulty.

So far there are 3 tables involved all of which are linked by a field called recipe_id:

Recipes

Recipe_LineItems

Production

On the Recipe table / layout i have a recipe name field there is a portal that is linked to Recipe_LineItem table which allows the user to enter each ingredient for that recipe.

That part is working great.

The problem i am having is with the production table / layout. On this layout, i have a field that is a drop down where the user can select a recipe. There is also a portal on this layout which i would like to use to show all of the ingredients for the selected recipe in the filter but i am unsure how to go about this.

I have attempted to set the portal filter to Recipe::RecipeName but that does not appear to work. Im pretty sure that's way off base but until now i have never done a filtered portal.

Any help would be appreciated.

Thanks

There's nothing to filter here. Assuming your relationships are:

Productions >-- Recipes --< Recipe_LineItems

Once you have selected a recipe for a production. the selected recipe's line items are the only line items related to the production.

I've made sure that my relationships were set correctly and they match what you have provided above.

My portal is set to show Related records from Recipe_LineItems

when i click the drop down to select the recipe, the portal remains empty.

Could the issue be that all 3 tables are related using the Recipe_ID field?

Could the issue be that all 3 tables are related using the Recipe_ID field?

What else would they be related by - if Recipes is the parent table to the other two?

Disregard. I took a look at it again this morning with a fresh mind and realized the Recipe_ID in the production record was not getting enetered which is why the portal was still empty.

Thanks for your assistance.

"when i click the drop down to select the recipe, the portal remains empty."

"the Recipe_ID in the production record was not getting enetered which is why the portal was still empty."

Selecting the Recipe_ID from the drop-down should BE selecting the ID. If it is reversed, i.e. you have the relationship based upon name and look up or auto-enter the ID then it should be corrected. Can you check the relationship and make sure it is properly set up as Recipe_ID=Recipe_ID. And check the value list and make sure it specifies ID in left pane and name in right pane?

If I'm incorrect, just disregard ... but it struck me that the relationship might be improperly configured. :smile:

Unfortunately at this point it doesnt matter because they now want to go another direction on this layout. Thank you all for your input as it will help in future projects.