This content has been marked as final.
Show 3 replies
-
Re: data model question
Gysbert Wassenaar Mar 15, 2017 2:03 PM (in response to Michael Granillo)They can give different results if a num value exists in both the Characters and Ascii tables, but not in the Transactions table. In the left data model Ascii and Characters are still associated. In the data model on the right they're not. So you wouldn't be able to see the related data in the Ascii table if you select a num value in Characters that doesn't exist in Transactions, but does in Ascii
-
Re: data model question
Michael Granillo Mar 15, 2017 2:29 PM (in response to Gysbert Wassenaar )That makes sense. Thanks. So the preferred method would be the data model on the left where all tables are associated?
-
Re: data model question
Gysbert Wassenaar Mar 15, 2017 2:39 PM (in response to Michael Granillo)That depends. Perhaps you have a good reason to prevent a direct association between the Ascii and the Characters table.
-
-