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

G_S
Bronze 3
Bronze 3

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

0 10 342
10 REPLIES 10
Top Labels in this Space