if you ever encounter this kind of error:
"The dynamic property of the field list of query data source 'MyTable' has not been set"
try this:
open query>DataSource>Field
Check property of filed it will have a property called "DYNAMIC PROPERTY" which is set to unspecified by default. Make it yes