How to know if a record is already in the table or is just in process to be created

Hi, I have to tables (TABLE A, TABLE B).
Columns In Table A

  • Name Account A
  • Type A

Columns In Table B

  • Name Account B
  • Name Contact
  • Cel
  • Email
  • Adress
  • Type B

In both of them are the column Type, so what I need is that in the TABLE B at column TYPE B desplay a dropdown of the diferent types that exist for that exact account in TABLE A.

In valid_if for TYPE B:

SELECT(TABLE A[TYPE A],[NAME ACCOUNT A]=[_THISROW].[NAME ACCOUNT B])

But it isnt working doesnยดt show any value. It is like the condicional is wrong. The condicional have to filter the list of type depending of the NAME ACCOUNT.

0 4 239
4 REPLIES 4
Top Labels in this Space