Forum Discussion
Append query
I am trying to append several entries from one table to another. I keep getting the error message, "An Insert Into Query cannot contain a multi-valued field." In the criteria row I put "between 07/01/21 and 07/08/21." When I chose Append Query, I chose the correct table from the Append to Dialog Box. What am I doing wrong?
- Correction to the last post. Make table queries are also not possible with MVFs
Sorry., my original reply didn't appear so the above comment made little sense.
Multivalued fields (MVFs) are in many ways a poor choice and most experienced developers will recommend avoiding their use. See my article http://www.mendipdatasystems.co.uk/multivalued-fields/4594468763.
The issue is that they depend on a deep hidden system table over which you have no control.
The error message is clear. MVFs cannot be used in INSERT (append) queries. This is the result of the deep hidden table. There is no simple work round. You will also be unable to use MVFs in make table or delete queries...though update queries can be done.
Recommend you replace all MVFs with standard fields, one value per record. You will find life becomes far easier
- Thank you. Are attachment fields MVFs? Also, are you able to do remote sessions?
