listbox source expr setting from databse option field

monir_asian

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?

mohana_cse06

monir_asian wrote:

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 ?

monir_asian

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.

Sog

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.

monir_asian

thanks