Create a recordset to return the captains name and ID
you will have another recordset on the update page that returns the data to be updated
add a select list to the page and populate it from the recordset. Set the value to the ID column and the label to the name column.
in the Select Value equal to section of the dynamic select list settings, click the lightning bolt icon and select the captain ID column from the main recordset.
in the update record behavior, bind the captain column to the select list