I am trying to make a dependent dropdown of data that is being referenced from two other tables. For example, Table A has info referenced from tables B and C and when I try to do the dependent dropdown, I am able to get it to work, but I can only see the ID’s I’ve created for Tables B and C.
Is there a way to get different names for the columns I am doing these dropdowns of?
most likely you’re SELECTing the wrong field in the SuggestedValues Or the Valid_If Values:
e.g. SELECT(Table[INFO], ([Whatevs] = [_THISROW].[Whatevs]))