AnsweredAssumed Answered

Yet Another Request for Help on Joining Records

Question asked by skineedog on Mar 27, 2011
Latest reply on Mar 30, 2011 by philmodjunk

Title

Yet Another Request for Help on Joining Records

Post

Ultimately I am trying to create a DB for recieps. Starting simple, will expand/extend after I learn a lot more about FM & DBs.

I have created tables as follows:

Recipe

Recipe ID <PK
Title
Category
Servings
Ingredients <FK
Instructions
Notes

Ingredients

Ingredient ID <PK
Ingredient

Recipe_Ingredient

Recipe ID <FK
Ingredient ID <FK

On the recipe form I have a portal set to show records from the ingredients table. I have poulated the ingredients table yet when I click in a field of the ingredients portal I do not get the drop down list of ingredients I expect. My portal has 12 rows. Although I do not see the ingredients I prepopulated the ingredients table with, I can create a new ingredient via the portal but only in the first row.

Screen_Capture_2011-03-27_at_8.16.12_PM.png

Outcomes