Jump to content

View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Caption for header on Excel

December 13, 200718 yr

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...