Updating a concatenated string

[ADixon]

I have a datasheet with info from multiple tables (SQL). Some of the columns
hold concatenated data based on an id number i.e. the fruit variety column
can hold multiple varieties, or the country of origin column can hold
multiple countries. I need to allow users to be able to access each of these
columns and change the values. How can i update the tables based on their
deletions, insertions or amendments?

 

[Marshall Barton]

I have a datasheet with info from multiple tables (SQL). Some of the columns
hold concatenated data based on an id number i.e. the fruit variety column
can hold multiple varieties, or the country of origin column can hold
multiple countries. I need to allow users to be able to access each of these
columns and change the values. How can i update the tables based on their
deletions, insertions or amendments?

There is a major design flaw in what you are describing.

A fundamental rule of databases is that each table field can
only contain a single value.

If your tables are properly normalized, then your user
interface has a problem in that you are presenting
information in a nice readable format, but then trying to
edit that formatted data. In this case, you need a
different mechanism for editing. Perhaps a command button
or double click event can be used to open a separate form
with an individual row for each of the editable values.