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