So, I recently came across an issue where we have the 'same' menu in three different languages, and the two 'specialised' languages had not been kept up to date.
I was trying to write a report component which compared usitem-usmenu with usitem_1-usmenu_1 (subtypes I created) where the first menu was language USA and the second one wasn't.
The usmenu_1 entity is automatically getting the relationship equivalent to usmenu (which includes the language), making it impossible to set a read trigger for where the languages are different.
I can't set up a relationship between usitem and usmenu_1 because it's a many to many relationship, in fact I can't set up the correct relationship between usmenu and usmenu_1, as the primary key needs an equivalent in both sides.
So, I could do this using a u_where clause if the usmenu_1 subtype was explicitly
not related to usitem. Is there any way I can remove the relationship inheritance specifically.
Iain
------------------------------
Iain Sharp
Head of Technical Services
Pci Systems Ltd
Sheffield United Kingdom
------------------------------