Referencing a sliced table showing all data with yellow warning

[VictorB]

Hi every one, 

I'm trying to show a list (ref drop down) of a slice in a form. But in the drop down all the ID's are showing with a yellow sign (error of ref) except for the ones present in the slice (show the name). 

The slice work fine when I test it and in views : 

I've tried to put an Suggested values expression to solve my issue but it did't help. 

[WillowMobileSys]

Ref columns MUST be assigned row references, i.e. the row key from the referenced table.  The yellow caution symbols shown indicate that those values are not valid row keys in the referenced table. 

Please show us the table source you are referencing and the expression you are using to get the dropdown list. 

[VictorB]

Hi WillowMobileSys, 

That's my table source :

That's the expression to slice the table Entreprise : 

IN(LOOKUP(USEREMAIL(); User; Email; ID); [User acces])

And then I'm calling the sliced table Entreprise from one other table to get the drop down 

[WillowMobileSys]

I can't match up what you have provide with the images in the original post.  In the original post you are showing a column dropdown that has the name of "Enterprise" at the top of the view. 

Which column is that?  And what expression do you have in the Valid_If (or Suggested Values) property of THAT column?

[VictorB · Accepted solution]

I found the solution thanks to your requests !

The dropdown from the original post is from this table, column ID Entreprise.

In the column ID Entreprise of the table Bon de commande (the dropdown) the Valid If was :

ORDERBY(Entreprises[ID]; [Nom])

I changed it to :

ORDERBY(Entreprises_User[ID]; [Nom])

Thanks a lot WillowMobileSys