Caption for header on Excel

[_henry_]

Hello all,

I want to ask for ideas how to format the caption header on Exporting to an Excel file with data gain from the relationship.

For example, if I have Contact database with ID (as Primary Key) and Item database (connected to Contact database with ID). Then, I created a new Layout which based database on Contact. In that layout, I want to include some information from Item Database. So, as a result, it would have Item::Item Name or Item::Item Price, as examples.

The thing is if I want to export it to Excel, the header would be fine for Contact database (Name, Address, Phone number, etc), however for Item database, it would be (Item::Item Name, Item::Item Price, etc). Is there a way or method to modify it directly the caption, so it would be shown "Item Name" and "Item Price"?

I am not sure if this has been discussed before in other discussion. If yes, please let me know the link. Thank you...