AnsweredAssumed Answered

Creating self joining relationships

Question asked by pleasehelpme on Jun 28, 2018
Latest reply on Jun 28, 2018 by pleasehelpme

I have two tables, one table that contains steps for each ID. one table that contains an ID, a prerequisite and up to three successors and a portal table with the steps for that ID on it. The prerequisite and successor fields contain IDs and I want to link them together so when I change something in the portal table in the prerequisite record it auto updates the first row in the portal table for one of the successors.  Also, It would also be nice to create related records based on the ID field and its contents in prerequisites and successors. If this doesn't make sense please ask because I am new to filemaker. Thank you for trying to help me.