Use name but store ID in select field

I have a name and an ID column in my database, I want to store the id in the field but use the name in the select menu on my form, any ideas how?

What does the select menu component look like?
In the label field use and in the value field use - provided your query is pulling the right info to supply the select menu

It does seem that the Retool Forms lack the option to assign label and value when selecting "Dynamic" data. It can be done when assigning Manual values.

How would you assign manual values?

In the "Data" section, select manual.

Then you can add your "name" values in lable and "id" in value.