Fetch the product details from 4 different entities

[TrushnaPawar]

I am designing a portal for order management. I have 4 different types product so while placing an order I need to show the particular selected product name and its price on order placement form. I am trying this using the lookup field but by default the lookup field only lookup for a single entity. Can you please suggest me any solution how can I achieve this?

[OliverRodrigues]

Hi, going back here to your data model, why would you have 4 different entities to represent a Product?

I would recommend you having a single entity to represent the Product, at least for the main properties of a product and if necessary 4 additional entities tied to the main Product Entity