I'm having problems with one of my lookup fields in an edit form. I have two tables in SQL. The main table has a column for PM name and then there is a PM table. In the Items of the cards I'm using ShowColumns which works just fine. In the datafield I'm using a lookup. The card value has a text bubble showing the correct name, but the dropdown menu always shows the first value in the table. I'm attaching a screenshot to help clarify what I mean. I have another lookup field to a different table that works fine so I'm not sure what I'm missing here.