Displaying data from 2 modules on same screen as part of single record.

[kallievz]

Hi All.

Need some assistance please.

I got 2 modules, where lookup data comes from one module, and the rest from other module. Now, building a screen, I can populate the lookups and searches from the UI, but how to display them in the grid as a column. I can create the record, but displaying it, I want to replace the "Id" fk with the actual Code/Description from lookup.

I know Product/Brand has this concept, but there is navigation in EF, and the spec return the response like that. In this case, it is from a different module, context does not allow to include the lookups in the spec, as it is not available during runtime.

Like referencing the User fromProduct to show who last modified/created the product, how then to display the UserName in the grid without the navigation?

new(rec => rec.TenantId, _localizer["TenantId"], "TenantId"),
new(rec => rec.AccountNumber, _localizer["AccountNumber"], "AccountNumber"),
// how to display data from other souce in grid????
new(lookup => lookup.value1, _localizer["value1"], "value1"),