Linktorow returning No items selected

[myra_o]

Hi I am trying to use the link to row to go from a customer list to a specific entry. I did it on another view and it worked just fine. I am trying to do it again and I am running into this. I am trying to go to a detail view for a piece of equipment based on the job name and field set in the customer table. This is my expression

linktorow([Field],"Swathing_Detail")

I have tried changing my key value to numerous things but this is what I have on the other behavior and works just fine. This is that expression:

linktorow([Field],"field_Detail")

When I click on the swathing one all I get is NO ITEMS SELECTED,. Any Ideas??

[Denny774]

Hey,

there is only one key (field) per table.
You can use LINKTOFILTEREDVIEW() instead.

Cheers

[AleksiAlkio]

Your "field" should have the key value from your Swathing table. If the value is something else, it won't find that record and that's why the message "no item selected".