Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Good Morning, Good Afternoon or Good Evening All o/
I have a testing data-model consisting of four tables:
The orders' market is stated as context on the Ancillary Order Info table while my revenue info is housed within the Order Line Item Details table. When I attempt to identify total billing my Market, I get the same value accross all markets. I have also attempted creating a markets key table like the OrderID's, but with the same result.
What am I doing wrong with the relationships/model?
Thank you for your advice and/or direction.
The Usurper
Thanks for jumping in to help, @amitchandak. To confirm: you're suggesting I rehash my "AncillInfo" table for orderid duplicates, then and if/when I find/correct those use the AncillInfo table as my "market" legend selector rather than creating a unique records table/key?