Show specific value in enum list based on another table related list

[G_S]

Hi 

I am having Five table 

1. Table A -----User
2. Table B---Floor
3. Table C----Group
4. Table D----Group User
5. Table E----Filter

In Group table I am having three column name 

1. Group ID
2. Floor-Ref of floor table 
3. Related Group User

In Group User Table I have three column

1. Id
2. Users-Ref to user table where email id is a key

In Filter table I am having column name Floor -Ref of Table B(floor)

What I need is I need to show the specific floor to only to the user in the related group user

Can anyone suggest expression to show only specific floor for user in specific group

[Marc_Dillon]

Show screenshots of the "Columns" page for each table. That's too complex of a structure to easily help you from a text description.

[G_S]

@Marc_Dillon 

User Table column

Group Table

Group User

Below is the floor column i have in filter table with ref of floor table 

I need to show the all the floor to every one but if any floor added in group table ,that should not shown to everyone ,only people I add in related group user should see that floor ,other should not be seeing or I need say the error msg in valid if other choose that floor 

Please help me with the expression for valid if

[Marc_Dillon]

I think this:

SELECT( Group[Floor] , IN( USEREMAIL() , [Related Group Users][User] ) )

[G_S]

@Marc_Dillon 

Above expression did not give any invalid error when i use in valid if 

what exactly i want is below is the screenshot of a group, I have added john smith user 

What I want is:

when anyone select Harding band building floor 1 ---it should through a error msg 

it should be valid only for john smith 

Below is the screenshot of filter table 

[Marc_Dillon]

I'm pretty darn sure that expression is what you need.

[G_S]

@Marc_Dillon I tried but it does not say any error msg

Can you suggest any other expression for valid if.

[G_S]

@Marc_Dillon can you suggest any other expression

[G_S]

@Marc_Dillon I tried above expression  but it does not say any error msg

Can you suggest any other expression for valid if.

[G_S]

SELECT( Group[Floor] , IN( USEREMAIL() , [Related Group Users][User] ) )

I used this expression in valid if but I did not get any error in floor column

[G_S]

Hi ,

Can anyone help me with some suggested expression to achieve the above requirement