Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried with Key
Load Rowno() as Key, Month from .....
Load Rowno() as Key, Plan_Date from ----
And then see, How DM visible?
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.
hi,
Please share a sample of your data
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
HI
These two list boxes are from same table or Diffrnt tables?
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
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.