[eluser]OverZealous[/eluser]
[quote author="rideearthtom" date="1268822125"]
Looking again at the error, it seems that DMZ is looking for a FK column name that matches the model name, not the table name. I.e., in the 'Pe_substyle' model, it's looking for 'pe_style_id' to make the join. But the 'Pe_style' model specifies that the table name is 'styles', not 'pe_styles'.[/quote]
It is (slightly) incorrectly documented. (A lot of the documentation is a mix of old DataMapper and new DMZ, so some of it isn't perfect.)
DMZ uses the $table->model field when generating the ITFK name. The biggest reason for the difference in the docs is that $table is supposed to be the plural form of the model. The real purpose of the override is for table names with unusual pluralization.
This is the exact quote on tables from the manual:
Quote:Normal tables must be named the lowercase, pluralised version of the object name. So for a user object of User, the table would be named users. For Country, it would be countries. (For odd pluralizations, you may need to hard code the $table or $model fields.)
So, it's not intended that you would have arbitrary table names. However, it should work in your case, just rename the ITFK column correctly.
It's not really a bug, just that you are using the application a bit outside it's intended design.
