Dependent Dropdown - Ref Columns (Label Problem)

Hi, i wanted to ask you some advice about the next situation.
I have a table (MOVIMIENTOS) with a referenced column to table PROVEDORES and another column called COMPROBANTE (wich is a number type column).
That said, i configured a dependent dropdown, so that in the RECIBOS table i can add some registers selecting the "PROV REC"  (from table PROVEEDORES) and i get filtered by "FAC REC"... so it will lead me to aply a receipt (recibo) to a "comprobante" filtered by "provider"... 
The thing is that, i get the "providers" (PROV REC) but, not its label... just de ID, wich is not desired, cause i want to select the "provider" (PROV REC) by its name (label)

I attached the screenshots of the tables and how i configured the dropdown, in wich you can see, in table MOVIMIENTOS the label is "Proveedor" , to take into consideration, and bring me some light here, jeje! Thanks!

JPAN_0-1672847188081.png

JPAN_1-1672847211944.pngJPAN_2-1672847219740.pngJPAN_3-1672847235847.png

JPAN_4-1672847372155.pngJPAN_5-1672847475277.png

 

 



0 2 77
2 REPLIES 2

Try setting the type of PROV REC in RECIBOS from TEXT to REF

Hi fellow, many thanks for  your help!! abording my incident!
I was checking that i commit a wrong data base aproach, so once i figured that out, everything worked as expected. Thank you so much, again! 

Top Labels in this Space