Hello Experts,
I have a scenario, where I have two tables say 'summer_data' and 'winter_data' and I have a single lookup filed in both the table named as 'week' from table 'Dimweek'.
I also have two entity forms for summer and winter data insertion in 'summer_data' and 'winter_data' respectively.
on those two forms I have lookup field 'Week'
Now, I want to restrict the 'week' lookup field to display only summer weeks i.e. between month May to August on summer form similarly I want to display week lookup field to display winter weeks. i.e. between December to Feb.
what are the best possible ways to achieve this?
Can I use different views from 'Dimweek' table to achieve desired result?
Please help me with this.
