Is it possible to see inside a mapping table?

[#1]

Hi, is it possible to see inside my mapping table?

1. I've got a standard table called tblActivity.

A resident load is done to get a mapping table:

Map_ActivityNo_Desc:

MAPPING LOAD

   ACTIVITY_NO

, DESCRIPTION

Resident tblActivity;

But how to I see what's inside this mapping table?

2.  What happens when the mapping table contents are not unique?  Does it just give you the first one?

[tresesco · Accepted solution]

To see mapping table, just load it as general table, like:

1. Load * Resident tblActivity;  // now, in the front-end you can see them.

2. Yes, it just gives you the first mapping result.

[jagan]

Hi,

Load the without the mapping keyword and validate the date, after that you again assign the mapping keyword, this is the way you need to do.

If the values are not unique then you will get the first record value.

Regards,

Jagan.

[#4]

Thanks tresesco and Jagan,

Much appreciated .

Jagan, I'm not sure what you mean by "validate the date" though... I don't see any date anywhere and I don't know exactly what to do to validate it.

[jagan]

Hi,

Sorry for the Typo mistake, it is data not date.

Regards,

Jagan.