LinkedIn
Twitter
Hi,
Is there any way to search the entire table that is referenced?
I have a Work order that I then select parts to “attach” to the work order via a ref column to the parts table. What I would like to be able to do is search the list of parts from the ref dropdown by either the PART NAME OR BARCODE or any other information that is stored in the parts table, just like you would if you were in the parts table. However from what I have read this is not possible and you have to use CONCATENATE([Part UPC]," “,[Part Name],” ",[Part Model]) and then have this set as the label for the parts table.
If all the above is true then I am still having problems with being able to barcode search. The [Part UPC] is a barcode enabled search column but I cannot put CONCATENATE([Part UPC]," “,[Part Name],” ",[Part Model]) as a barcode enabled search because it is a virtual column. Where am I going wrong?
Please let me know.
Thanks!!
