I was able to create the necessary models and connect to the correct data, but now i’m having an issue applying the condition to the primary model.
Basically, I have a list of records, each with a SUPPLIER field. I also have a model which lists all available users and has the condition to only output the current user. This user model seems to work fine. Finally, I then add a condition to the main table so the SUPPLIER = USER.COMPANY NAME. The values definitely match. When I hardcode the COMPANY number (i.e. SUPPLIER = “9999999”), the condition works properly, but with the USER.COMPANY lookup, the condition is not outputting any records:
The image above shows the user info on the left (see the company name) and the main table on the right (the condition is removed for this image). The COMPANY NAME and SUPPLIER fields match.
This second image is the condition added to the main table which links the Supplier field to the User model > Company Name field.
Does anyone know why this condition isn’t working? This is a crucial element for my project and my last big hurdle. I’d really appreciate some help on this one…