Enable Filter option of all given records in a linked txtbox

Joseph_Noufaily

Hi,

I'm using Navision 2009 R2.
First I created a new page "X" and linked it to the table comment line (ID 97).
Then i added a field to table comment line called "source" and gave it a table relation with "Work Type".Description.
Table work type has the following fields (Code, Description and Unit of Measure Code)
Then on page X i added a text box called "Source" with SourceExpr Source.

The thing is that when i access page X and try to fill in data in the Source text box i can only filter on the field Code while Description and Unit of Measure Code are not activated for filtering.

Thank you in advance for any help.
Regards,

geordie

I don't know your requirements, but are you sure your field must be linked to "Work Type".Description? It has more sense to link it to "Work Type".Code, which is the primary key...

Joseph_Noufaily

I'm sure of the link since when i access the form and try to input data in the text box "Source" i can search the table work type from the text box based on the field WorkType."Code" only. I want to be able to filter the data based on the other fields also (WorkType."Description" and WorkType."Unit of Measure Code" )

geordie

On Work Type table is the DropDown field group still standard (so, all the fields are included)?

MBerger

You can only filter on fields in a dropdown if there is a key for that field, as far as i know. so make a new key ( or more than one ) and try again.

Joseph_Noufaily

@MBerger thank you for the help the issue was solved