Populating Portal based on results in another table - Need assistance

Discussion created by mdsilvers on Mar 17, 2014
Latest reply on Mar 17, 2014 by mdsilvers

I need some help. I’ve hit a wall on trying to figure out a solution on how to add rows dynamically to a portal based on flags in another table. In my mind I think this should be possible in FMP, but I’m used to working with PL/SQL and other languages where I have full access to easily setup and manipulate data.


I have a table for ‘Crew’. It is basically a table with names and personal information. One field is called ‘Default Crew’ and is either Y or N.


I want to be able to populate rows in a portal for another table - called Trip Crew - by the user pushing a button that will automatically add the crew_ids from the Crew table to the portal based on the flag being ‘Y’. At this point I’m not sure how to tackle this item in FMP 13. Any thoughts? Thanks for your help.