Selecting the dates in Two List Boxes

[rajkumarb]

Hi Experts

I Have an Issue in selecting date fields in Two list box, if a select a particular date field in one list box I want the other date field in another list box to be selected as well, How Can I do this, Please advise

[Gysbert_Wassenaar]

On the Triggers tab of the Document Properties window add a Select in Field action to the OnSelect field trigger of the first field. Use as target field the name of the second field and as search string the name of the first field.

[rajkumarb]

HI Gysbert

Thank You for your Answer

I did that in the way you mentioned

MY first field is Dedate and the object Id is LBO2

My Second Fiels is Saledate and the object Id is LBO9

on the field events trigger  -> Dedate -> on select-> Select In Field ->  Field ->LB02 & Search String -> LBO9

And its not working  Please advice

[kuba_michalik]

Don't use listbox object's IDs, use field names.

[rajkumarb]

Hi Jackub

I Changes it to Field Name

Its not Working, Any suggestions

[kuba_michalik · Accepted solution]

Eh, you are right of course, you can't just input another field's name as a search string...

Use this here abomination:

='=Only({<Saledate =$::Dedate>}Saledate )'

as the search string instead. There is probably a simpler way I can't remember at the moment

Have a look at the attached example if in doubt (trigger set for F1 OnSelect in the example)

[rajkumarb]

Hi Jakub

Thank  You

It Worked

[Anonymous]

Hi Raj Kumar,

try like this

Triggers -->Select the field which --->onSelect -->Action-->Selectpossible --> enter the field name which you want the data to be selected -->ok