Common Selection

[#1]

Hello,

I have month field in common calendar and one field Plan_date in Other List box.

i want relation btwn those two fields if i will select the month then in plan_date should be select that particular month.

any help will be greatfull.

Thanks & Regards,

Qliker

[Anil_Babu_Samineni]

Have you tried with Key

Load Rowno() as Key, Month from .....

Load Rowno() as Key, Plan_Date from ----

And then see, How DM visible?

[#3]

Demo,

I have two list boxes .

[Month]                

jan

feb

march

apr

may

jun

.....

[Fiscal Month Year]

05-05-2016

08-06-2016

10-07-2016

20-08-2016

so i want if i will select the june from month list box then should be select 08-06-2016 from Fiscal month year list box.

[sasikanth]

hi,

Please share a sample of your data

[pradeep_s]

Hi Abhishek,

You have to create a link between those two through keys.

Alternately, you can also use triggers/Expressions(using variables) to achieve the same.

Thanks

[sasikanth]

HI

These two list boxes are from same table or Diffrnt tables?

[Anil_Babu_Samineni]

Would you provide sample

Or, Try like this from your script

Original:

[Month]               

jan

feb

march

apr

may

jun

LinkTable:

Month

Fiscal

Fiscal:

[Fiscal Month Year]

05-05-2016

08-06-2016

10-07-2016

20-08-2016

OR

[Month]               

jan

feb

march

apr

may

jun

.....

Month, [Fiscal Month Year]

May, 05-05-2016

Jun, 08-06-2016

Jul, 10-07-2016

Aug, 20-08-2016

[Anonymous]

Hi,

If [Month] and [Fiscal Month Year] are in 2 separate tables, you could add this to the load script :

Load

      [Fiscal Month Year],

      Month(Date#([Fiscal Month Year],'DD-MM-YYYY')) as [Month],

      ....

This will convert the date into month, thus creating a link.