Unable to look up associated data


I’m trying to concatenate a string based on a selected value in a drop down. The data I am putting together is data that has a relationship to the table in the drop down.
It doesn’t work until, as in it can’t display that data. But if I load up a modal that has access to the same table, then cancel (back) it starts working.

What am I doing wrong or is this a bug?

Step one - select data in drop down. You can see the string below isn’t showing the related data

Step two - click + to load up form, and then Cancel

Step 3 - Data is now displayed and works properly every time, even if I move away from this screen and come back

Database - you can see they are related tables

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.