Temporarily disable TableRelation

davemaclurg

I have a table which contains and EntryType field and a MatufacturerCode amongst others.
The ManufacturerCode field has a TableRelation. if the EntryType is not Manufacturer then the relation is to the same table with a filter of EntityType = Manufacturer.
I have a List Form which displays these fields. The ManufacturerCde field has an upward arrow which allows a look up when the EntityType is not Manufacturer. When the EntityType is Manufacturer the arrow is there but does not do a lookup.
Is there any way I can hide the upward arrow when the EntityType is Manufacturer?

DenSter

I don't think you can. Once a tablerelationship is defined, the up arrow is displayed. When the tablerelationship is then further defined as a conditional one, the up arrow remains visible, but it just doesn't do anything when you click it.