Records not visible in portals

See if this helps. If you need a different version of FileMaker < 12 let me know.

change the 000wrongNumber to the correct number matching Member Position numbers to see it update

Download

Your setup sound correct. I wouldn't expect you to need a portal filter, so the possibility that you have a portal filter that is excluding the records is unlikely.

Best guess is that the values in the Evaluation::id_memberposition fields do not match to the value of Member Position::id_memberposition and thus do not appear in the portal.

You may want to copy the value of id_memberposiiton from your current Member Position record to the clipboard, switch over to a layout based on Evaluation (a table view can be very helpful here), enter find mode and paste the value into the id_memberPosition field and perform the find to see if any records are found. When you do this, enter ==", now paste and add a " after the pasted text. This will search for exact matches and not just entires that start with the same characters or that might look the same but have leading or trailing spaces (or other invisible characters). This last issue is something that can keep records from matching if your id fields are of type text instead of number.

Um yeah and it's one that's created a few forehead shaped dents in my monitors over the years. The variable in your set field to assign an ID to the new record is named differently than the one in set variable step that is supposed to be capturing that value. There's an underscore in the one that is not in the other so your set field is referring to a non-existent variable and thus assigns no value to the new record's match field.

But you do know that if you enable "allow creation" for the evaluations table occurrence, you can simply type data into the bottom "add" row of the portal and create a new record with matching ID's entered for you? I realize that there are advantages to the scripted approach if you have a lot of stuff in the portal and don't want to keep scrolling the portal to get to the add row, but it does avoid the need for any script at all for creating new evaluation records.

(And I would not have name fields in the evaluation table nor a position field. That creates a second, redundant copy of data better kept in the original table. Given your relationships, it's usually quite simple to just include the field from the appropriate related table instead of copying this data from table to table like this.)

I've been doing this for quite a few years (Since FMP 2.5) so when you indicated that the field was blank, I had a pretty short list in mind of ways that might happen before I even looked at your script.

For what it's worth, I've taken to copying the variable name to the clipboard from whatever script step or calculation creates the variable to paste into subsequent expressions that reference that precisely because there are no warnings that pop up to tell you that you mistyped the name of the variable.

As to your question: probably. You might be able to manually enter the needed values, if there aren't too many to fix and if you can tell by inspection which evaluations link to which join table records.