REF Different tables in the same app

Hi

I am trying to create a drop-down column in Table C from table B based on an answer from table A. For Instance

Table A is my customer list

Table B is my Job List

Table C is my Commissioning App

In Table C I select the customer based on results from Table A (Which works fine). I then have a column called job number in Table B and a column called Job Number in Table C, I want Job Number in Table C to have a drop down with job Numbers that have the same customer Name.

I hope this makes sense

Thanks

Blake

Try:

IFS(
  ISNOTBLANK([Customer]),
    SELECT(
      Table B[Job Number],
      ([_THISROW].[Customer] = [Customer]),
      TRUE
    )
)