Conversion failed when converting the nvarchar value 'X' to data type int.

[tonykiefer]

I have a form with a set of Cascading dropdowns/comboboxes on it.

The combobox "Component 2" is setup this way...

The combobox does retrieve the filtered selection...

The problem occurs when I filter the view to return a specific column like so...

The view schema...

The query result using the myPLM_BOM_ID onscreen value...

and the onscreen error when I change the Items property to include the filter column...

It seems I cannot add any additional parameter to the filtered list without getting this error.

I'm not really sure why the Item's Property won't return the filtered record set.  Any help will be appreciated.

[RandyHayes · Accepted solution]

@tonykiefer 

Your filter syntax is incorrect.

Change to the following if you only want one column.

Filter(VW_DELETE_COMPONENT_FROM_BOM, Component=myPLM_BOM_ID).PLM_BOM_RESULT

I hope this is helpful for you.

[tonykiefer · Accepted solution]

@RandyHayes ...it worked...Thank you very much for the pair of eyes.  I guess I tried applying dropdown syntax to a combobox.

[RandyHayes]

@tonykiefer 

I've done it before not thinking straight...extra eyes always help!