deehutchins
Registered User.
- Local time
- Today, 05:09
- Joined
- May 30, 2014
- Messages
- 49
Good morning any and everyone,
I am in need of some very detailed/step by step assistance and fixing my append/update query. To start I know it is a shame on me moment for using a multi-valued fields because it is a known problem child, but it was a mjor request by my co-workers in the review of the development. :banghead: So, with that being said, I am now being asking to move all the data from one table to another table within the same database with the same column names (with different table names), but the problems is that I keep getting the error fro multi-value fields are not accepted in both the append and/or the update.
Please note: My multi-valued fields have a list of values within them e.g. Type of Request has values of BVD, CDA,NF,PA,QL,ST,TL and there a few more like this I need to be able to move the data over regardless of the user choice.
Hope this help to help me......lol
Thanks in advance,
I am in need of some very detailed/step by step assistance and fixing my append/update query. To start I know it is a shame on me moment for using a multi-valued fields because it is a known problem child, but it was a mjor request by my co-workers in the review of the development. :banghead: So, with that being said, I am now being asking to move all the data from one table to another table within the same database with the same column names (with different table names), but the problems is that I keep getting the error fro multi-value fields are not accepted in both the append and/or the update.
Please note: My multi-valued fields have a list of values within them e.g. Type of Request has values of BVD, CDA,NF,PA,QL,ST,TL and there a few more like this I need to be able to move the data over regardless of the user choice.
Hope this help to help me......lol
Thanks in advance,