I have a StockItem table which has Stock Item ID, Barcode & Stock Item Name, named as SID, Bc, SIName and some other columns… Attached Snapshot.
I have created a TestBarcode Table and its form, attached Snapshot. Barcode Column is Tick Marked on Search and Scan and the StockItem Column is Referencing the StockItem Table.
In the StockItemVirtual Column I am able to get the Name of the StockItem when we scan the Barcode and the particular product is listed in the StockItem table by using the App Formula SELECT (StockItem [SIName], [Bc] = [_THISROW].[Barcode]). I want the Same to come in the StockItem Column which is of Ref Type and is referencing the StockItem Table and if the Barcode is not found it should let me select the Stock Item Manually from the Dropdown as Some Stock Items like Service Charges Router Setup is a Service and does not have a Barcode so I should be able to select that from the Drop Down List.
Please let me know!! Thank You