function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
JohnCutJohnCut 

Redundant Relationships

Hello. I am faced with a problem. I have created some custom objects:

An Order has Order Items

An Order is related 1:1 with an Opportunity

and obviously an Opportunity is linked to an Account

I have another object which is related to Order Items. The trouble is that when a user goes to lookup an Order Item, they find it easiest when the Account Name is in a column. I have yet to find a way to do this without

1) Writing S Controls
2) Adding redundant fields (like Account), and doing a lot of checks with S-Controls (to make sure someone doesn't change the Account etc.

Any thoughts? Which road should I go down?

John