I have a Visual Basic form that is using two tables from an ACCESS database. The form displays a single item/part/assembly data from an item table. Additionally, there is a datagridview that shows a list of vendors (from another table) that provide the item (see form below).
Each item record has a unique 9 digit ID number. e.g. 901003111. In the vendor table each vendor record has a text field that contains each of the item ID numbers of the items associated with that vendor record. The field might look like this:
901003111, 100234758, 111900231, ........,
Currently, the values in this field are comma delimited. The reason for the multiple values in the field is because a vendor might be a source for more than one item.
So what I am trying to do is to display an item, like in the form below. Then run a fill query that would search the Vendor records ID field for a value that matches the Validation ID # shown in the form and then display all of those Vendor records that contain that value in the datagridview.
Can anyone explain to me how to search through the field to find the matching value?