Web app: set default value in a dropdown based on a field value (Xano backend)


I am having an issue setting the default value of a dropdown the value of the records stored in the xano db.

here is the scenario:
I have a relationship between two tables and am storing the id of table two in table one as a reference. When I retrieve the record in table one and display it on a screen, I have a dropdown component with a list of records in table two. when I render the screen I cannot set the value in the dropdown with the value stored in the record one table as the default value of the dropdown. is there something I need to do to get this to work properly?