AnsweredAssumed Answered

Basic Relationship Question

Question asked by ArtWheat on Apr 25, 2012
Latest reply on Apr 25, 2012 by philmodjunk

Title

Basic Relationship Question

Post

I have two tables inside one FMPro 12 file. ToDo and Projects.

Each table has a key field: ToDoID and ProjectsID

I made one to many relationship in the Relationships dialog box between the two ID fields (not sure how to make it many to many and if that is what I need).

In the Projects table, I wanted to create a portal to view all the ToDo's of an individual Project yet when I add the portal, the Portal dialog box asks me to show related records from <unknown>.

 

I've search the knowledge base as I'm sure this is a common question but have not found what I need to resolve this. Feeling like a noob, but not to proud to ask for help.

Appreciate it if anyone can point me in the right direction.

Thank you,

Art

relationship.png

Outcomes