+ Start a Discussion

Is there such a thing as Intermediate Tables?

Is there such a thing as an intermediate table in SalesForce? By this I mean, I have two types of products (hardware and software). I would like assets to point to only hardware products and my custom object 'assays' to point to only software products.


I'm thinking that it would work if I could have an intermediate table that holds only one type of product (but would be updated everytime somebody updated the product table with the appropriate type of product.)


Thanks in advance!


Hi Jill,


I think there's a feature on the roadmap that will allow you to set filters on lookups so that when a user go to select a product, for example, it would only show the hardware products. For now, though, you could add a validation rule on Assets that checks the product type to make sure it's hardware, and another one on Assays to make sure it's software.