Options

listbox source expr setting from databse option field

monir_asianmonir_asian Member Posts: 80
edited 2012-03-30 in NAV Three Tier
I have a "season" option field in Itemledger entry table and option string is " ,Spring,Summer,Spring-Summer,Autumn,Winter,Autumn-Winter"

I am trying to make a report and need a listbox for season field.
I want to set listbox source expr =Itemledger entry ."Season".



But it is not working.

It works when i create a global season option variable . I want to take data direct from Itemledger entry table field.

how to do this?

Comments

  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,503
    I want to take data direct from Itemledger entry table field.
    What does this statement mean?
    you want to apply the filter directly without writing code?

    If Item Ledger Entry is your dataitem then did you try by adding season in ReqFilterFields ?
  • Options
    monir_asianmonir_asian Member Posts: 80
    I do not want in request filter field.

    I want to add this on option form and want to add source expr of textbox field=Itemledgerentry.Season that data can come from table.
  • Options
    SogSog Member Posts: 1,023
    It works when i create a global season option variable . I want to take data direct from Itemledger entry table field.
    You have 2 choices, either create a global season option var and it will work.
    Or you create a global rec variable of item ledger entry that you only use to let the user select the optionstring in a field.
    Like globalrec.season.
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • Options
    monir_asianmonir_asian Member Posts: 80
    thanks
Sign In or Register to comment.