Extended Item text in Item List View

ADARTIHS

Hi Everyone 8)

Version : NAV 2009 SP1
Database: SQL

I am trying to bring the first line of the Extended text value into the Item List form. So I created a new field in the Item Table and in the Properties I created a Table Relation with the Extended Text Line table with the following properties:
Table: Extended Text Lin
Field: Text
Table Filter: No. FIELD No.
Line no. FILTER 10000
Table Name FILTER Item

I get no values coming from the extended text table and if use the flow field I get the following error:

The following field must be included in the table's primary key.

Field: Text
table: Extended Text Line

Please HELP.

Thanks

ADARTIHS

Belias

table relation is the not right property to use...you should instead create a flowfield of type lookup.

ADARTIHS

Thank you very much Belias this works Great!!

I cannot believe I missed that!!

Belias

you're welcome! be aware that the list you can degrade performance if you add a flowfield to a list form...*if possible*, add it to the card instead.