Forum Discussion
DataUsurper
6 years agoHelper II
Data-Model Snag
Good Morning, Good Afternoon or Good Evening All o/ I have a testing data-model consisting of four tables: Calendar OrderID Key (Unique Records) Order Line Item Details Ancillary Order Info ...
amitchandak
6 years agoSuper User
I think those tables are still in Many to Many relation. All unique Order related information should be part of the order table
- DataUsurper6 years agoHelper II
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?