Conditional Selecting Values of a Field Based on Logical Condition

Discussion created by kstirto on Sep 28, 2015
Latest reply on Sep 29, 2015 by kstirto

Dear members, I need some help here after pulling my hair this past 2 days... I have "Customer" table with IsReseller field as Boolean. I also have "Products" table with 2 numeric fields: SellerPrice and ResellerPrice. In my "OrderLineItems" table I have a field called UnitPrice that I would like to select and copy the value of ResellerPrice if the IsReseller = True and copy the SellerPrice if IsReseller is False. How could I achieve this? Thanks