New Bug Encountered: ref pulls wrong column

[Olivia_Bryanne1]

Hi there,

I’ve linked two tables and made a form for the second so that once the ref field is set by the user using a dropdown menu the other fields in the form will autopopulate. The ref works fine and pulls the right entry, but the autopopulated values to not correspond to the right columns - e.g. the field Name pulls the parent entry’s email address instead. It’s the right row, just the wrong column

Any suggestions?

Olivia