Confused about using a field in a table for a pop-up menu
I have a Projects table with "Project 1", and "Project 2".
When I select to have these two projects appear using the actual field (using "Values from") in the projects table in a pop-up menu, everything's fine.... at first.
However, when I go to another layout and then come back to the projects pop-up menu (on the project's layout), the Project 2 field was overwritten and now also says "Project 1". I think the issue is when I select the second project in the pop-up menu, that it's somehow writing back to the projects table instead of just being a pick list.
The only way I seem to be able to get the desired behavior is to create a static projects list.
So, how do I use a table's field (like project description with multiple rows in the project table) to create a pop-up list to pick from, but without FMP overwriting the project table when the user picks a project name from the picker?
Thanks in advance.