You need to sign in to do that
Don't have an account?
crusoeda12
Relating object back to itself (many times)
Hi there,
I have a list of products, and would like to relate each product to other products. I can create a lookup relationship, but this isn't quite right; each product has one, but in most cases more, related projects. How can we create this relationship?
I have tried:
Master-Detail through a connector object (doesn't seem to work, since the connector objects have to be unique)
Lookup relationship (doesn't seem to work because the lookup can only be to a single instance of each object)
Any other ideas?
Thanks!
--Dave
So, I think I have one solution:
Instead of building the normal Connector object for Many > Many, I created 1/2 of that. The parent object is the same (in this case, PRODUCT, but the second field on the object is a lookup.
This creates the perception of multiple related items, through a connector, to the object itself. So:
PRODUCT 1 > Connector > Product 1 (Master-Detail) Product 2 (Lookup)
Any reason this will blow up my app?
Thanks!
--Dave