Yet Another Request for Help on Joining Records
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 ID <PK
Ingredient ID <PK
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.