Illegal field name
Posted: Tue 14 Jan 2014 18:17
Hi
When I try to do a Master/detail relationship using renaming in the detailpart, like User as Bruger, the detailpart fails with an Illegal field name.
An example:
I have two tables, the master-table, Users, which contains all the registrered users, and a History table, containing everything which has been done by the different users.
I want to show for each user what the particular user has done, that is, show all the items the user has done something with.
So I make Users mastertable, History the detail table. The detail MsQuery gets a MasterSource=Users, and a MasterField=User and a DetailField=Bruger
Remember that Bruger's true name is really User, but I want to be able to use other languages, and in Danish (my language) User is called Bruger.
So far, so good. But when I click activate, I get an error: Bruger invalid field.
This seems to fail in all circumstances where the DetailField is not a proper fieldname. It is like Master/Detail relations cannot handle as name in the detail part.
If for instance you want to use years, you will do something like Year(TheDate) as Aar. This fails with Illegal field name.
Any suggestions?
Best regards
Poul
When I try to do a Master/detail relationship using renaming in the detailpart, like User as Bruger, the detailpart fails with an Illegal field name.
An example:
I have two tables, the master-table, Users, which contains all the registrered users, and a History table, containing everything which has been done by the different users.
I want to show for each user what the particular user has done, that is, show all the items the user has done something with.
So I make Users mastertable, History the detail table. The detail MsQuery gets a MasterSource=Users, and a MasterField=User and a DetailField=Bruger
Remember that Bruger's true name is really User, but I want to be able to use other languages, and in Danish (my language) User is called Bruger.
So far, so good. But when I click activate, I get an error: Bruger invalid field.
This seems to fail in all circumstances where the DetailField is not a proper fieldname. It is like Master/Detail relations cannot handle as name in the detail part.
If for instance you want to use years, you will do something like Year(TheDate) as Aar. This fails with Illegal field name.
Any suggestions?
Best regards
Poul