I feel I should know this but just not coming up with a solution.
I want to simulate the REF_ROWS() function but need to select rows by more complex criteria than matching columns between the two tables.
Here is my use case:
I have Products, Options and Customer Discount tables. My goal is to show a Product Pricing view and show all of the information that can affect the final price of that product - Base product price, Option Prices and all relevant Discounts. However, while some Customer Discounts are by an individual product, others are a Discount that applies across the board to all products.
So, I want to create a Virtual Column that pulls ALL discount records together and not just match by the Product I am currently viewing.
I can create this VC with no problem but now I want to display it as an Inline Table and not just a list of ID’s. Is there a way I can do that?