I believe the correct way is to define the view in your mySQL database as I have contended. Thank you for pointing out this missing feature. You are the first to report it, so it isn't very common for our users to deal with multiple primary keys. I will add it as a feature suggestion for the next release, but no amount of hand waving will make it work the way you want. You either need to create a view in the mySQL database or possibly debug and hack your way through adding this feature to DataAssist because the feature does not exist currently.