I have the following situation.
1. Inventory stock is taken in meter.
2. An item is of 2,...,6 mtr.
3. Made 2 UDFs
3.1 Length of an item in meter(drop down of 2,...,6)
3.2 Actual stock in piece.
4. I want to have a FMS so that when i give value in 3.1, 3.2 will be filled in as [Stock/3.1 UDF)
5. Wrote a query like
Select T0.[U_Stock_in_pcs] as T1.[OnHand]/T0.[U_meter_per_piece] from OITM T0 INNER JOIN OITW T1 ON T0.ItemCode = T1.ItemCode