Format as Filters

sabzam

Dear All,

I have got a no. of records and I would like to show them one near each other in the same ways a multiple key is shown in one line. Is this possible?

Alex_Chow

???

Maybe you can draft what you'd like to see on Excel.

sabzam

Let's say I've got a three records of type code for example:

Txt1
Txt2
Txt3

The resulting line should Txt1,Txt2,Txt3

Savatage

sabzam wrote:

Let's say I've got a three records of type code for example:

Txt1
Txt2
Txt3

The resulting line should Txt1,Txt2,Txt3

fulltext := Txt1+','+Txt2+','+Txt3;
You mean some thing like this?

or ('%1,%2,%3',Txt1,Txt2,Txt3);

kine

And are you sure that it will fit the 250 chars or 1024 chars in all cases?

sabzam

I am not sure how is it coded to be honest. I am depicting it the way as the Keys in a table are shown, and they seem not to have any limits in terms of characters. I am not sure how it can be done though in Navision. I have thought of text variable as well but was not sure whether that was the optimal solution.

Savatage

Perhaps if you explain with a little more detail what you are trying to do. Right now we're guessing.

sabzam

Let's take for example a table whose primary key is field1, field2, field3.

When setting up the primary key one clicks on the button and finds a list form in which one has to set all the fields, one under each other. Once set the user clicks ok and the list of fields which make up the primary key will show up one by each other. I need to recreate the same funcitonality for a field in a table.

A clear example would be the primary key of the Gen. Journal Line table.