Hi,
I have an app I've built that currently pulls a data from an excel file on sharepoint. The user uses a combobox to select the item they want to view. Due to the large data set I want to filter the data before it reaches the combox.
The connection is called dbCameras, comboc box is called cbModel
currently the combo box items looks like this
cbModel.Items: dbCameras
I want it to be filtered by the Manufacture field in the data. I was thinking this:
cbModel.Items: Flter(dbCameras, dbCameras.Manufacture = "Sony")
I can't seem to get it to work. Any ideas how I can do this?

Report
All responses (
Answers (