Setup:
Tables:
Products (Product_Id, Product_Name, Product_Code...)
Orders (Order_Id, Order_Number, Date, ...)
Order_Items(Item_Id, Order_Id, Product_Id, Qty)
Links:
Products -> Order_Items
Orders -> Order_Items
Question:
Order Item table, "Product_Id" field I have configured as lookup, where Product_Id is the value and Product_Code, Product_Name are the display values. Product_Code and Product_Name are displayed as comma delimited in one column, I would like to have then in separate columns, what is the recommended way for some situation? Custom View or Custom Template or something else?
Thanks