I have created a cascading lookup column field for a list in sharepoint 2010. It's working fine in the Standard view but not in the DataSheet view.
In datasheet view it is showing all the possible options in child column; it isn't applying the parent column's filter.
For example: If you select the country India in the parent column, it should only show Indian countries in the child column; but in the DataSheet view it's showing all the other options.
How can I change the behaviour of the child column to filter the available options??