On 3/6/23 12:48 PM, Brad White wrote:
LOL Joke's on me. Here's the relevant part of the view SELECT ... "Order Items"."ID" AS "OrderItemID", ... (("Orders"."ID" || '-'::text) || "Order Items"."ID") AS "FileKey"\
Because "Orders"."ID" is different then "Order Items"."ID"?
Wait, then why are the Item IDs different?
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx