Insert into query cannot contain a multi-valued field

[psamu]

i trying to remove and archives data from a table that has relationships to other table But I am getting error message "Insert into query cannot contain a multi-valued field". I would like to know is there any other way I can work around? I just want to remove data and append to other table based on user input date parameter. Thanks

 

[ranman256]

Are you trying to insert data into the multi-value field? you cant. you cant use queries for this. you must use VB.
BUT
if you are trying to inert records into a table, then its a simple sql statement. But you cant use a multi-value field as reference.

 

[psamu]

Yes I am using attachment field and another multi-valued field. Is there a way to use vb code or seql query with parameter to remove and archive data into another table? Thanks for the help