Hello,

I have two custom entities, Serial and Inspection. The serial entity is a serialized product, and has columns like model number, description, work order, etc.

The inspection entity would be a child of the Serial (i think?). When the quality team performs an inspection, they will create a new Inspection in CRM, and enter the serial # from a SSA field. My question is, once a serial is selected, how I can display the serial entity columns in the inspection summary/details screen, without having duplicated columns in the inspection entity (i.e. insp_modelnumber populated from seri_modelnumber). Is this possible? Similar to when you are on the detail screen of a Person entity, the Company block is displayed on the bottom.

I'm not sure if I explained it right, but if I were to create a website from scratch, and I wanted to display an Inspection to the user, the sql call would be something like this

select
i.type,
i.date,
i.passfail,
s.serialnumber,
s.modelnumber,
s.productline,
from
inspection i
join serial s on s.serinumber = i.serialnumber
where
i.serialnumber = 1234

Fairly typical for relational db's.

What I'm trying to avoid having to do in Sage CRM, is adding a column like inspection.modelnumber, and having to populate that by making a crm.sdata call to find the serial.modelnumber. That results in having the same data stored in two different tables.

Thanks for any help!

Joe