but I’m used to working with PL/SQL and other languages where I have full access to easily setup and manipulate data.
Which you think is not possible in FileMaker?
You can write a script along the lines of
Set Variable ( $defaultCrewList ; ExecuteSQL ( "SELECT primaryCrewID FROM Crew WHERE defaultCrew = "Y" ; "" ; "" )
# I suggest using 1/0 as Boolean value(s)
If ( IsEmpty ( $defaultCrewList ) ]
Set Variable ( $tripID ; trip::tripID ]
Go to Layout ( TripCrew ( TripCrew) ]
Set Variable [ $i ; $i + 1 ]
Set Field [ TripCrew::_fk_tripID ; $tripID ]
Set Field [ TripCrew::_fk_crewID ; GetValue ( $defaultCrewList ; $i ]
Exit Loop if [ $i = ValueCount ( $defaultCrewList ) ]
Go to Layout [ original layout ]
Have fun with FileMaker!
Thanks Erolst! I’ll give this a try!