Basic Relationship Question
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.