Multiple value check list load from table

[livr]

We use some multiple value fields where users can check multiple values.


Within a new form we want to load the contents of a multiple value field from a tabel (we have made the query for this and get the multiple values) in a new field and use it as a multiple value lookup field.

This does not work.

We get an empty field.

How can we see the selected multiple items from the query in the field on the form(table lookup)?

Example:
John; Peter; Ted (is selected in the multiple value field)

Get these values from the tables in the database.
Then in another form:
Load these values in a new multiple value field:
See the selected items: John and Peter and Ted.

[orange]

Why are you using Multivalued fields?
Can you Not use traditional tables and fields and RDBMS principles to accomplish what you want?

Many people who have mulivalued fields available to them, choose not to use them.