Append Table Data With Multi-Value Fields

[raychow22]

Hi Forum,



Is it possible to append "Table" data from one Access file to another Access file with Multi-Value Fields within the Tables?

Or would it be simplier just to make these fields in the "Table" just text boxes?

Thanks,
Raymond

[rpeare]

Your question is not clear enough for me to give a definite answer to your question but, in general, multi value fields are an extremely bad idea. They make queries/reporting/coding much, much, much more difficult. That being said, if the two tables had exactly the same data structure, I do not see any reason an append query wouldn't work but I honestly have never tried to append data from a multi value field into another multi value field.

[raychow22]

Your question is not clear enough for me to give a definite answer to your question but, in general, multi value fields are an extremely bad idea. They make queries/reporting/coding much, much, much more difficult. That being said, if the two tables had exactly the same data structure, I do not see any reason an append query wouldn't work but I honestly have never tried to append data from a multi value field into another multi value field.

They both have the same structure. But message says I cant append data from a multi-value fields.

Here is a snapshot.



Can my solution be use multi-value fields in my "Forms" and then leave fields as text boxes in my "Table"?

[rpeare]

it depends on what you are storing in your multi value field. If it's something like a keyword string, then yes, you could, as long as you are were storing the string and not the primary key value. If it's something where you'd want to actually do something with the data other than just examine it as a string, then no, it would be a bad idea.

[raychow22]

I just want to be able to easily append my "Table" data from another access file. Since I can't append them with Multi-Value fields. Are there any alternatives to not using Multi-Value fields? I don't want to use Single fields because I would have to create more fields in my "Forms" is there another way to do this?

[rpeare]

VBA Code, that's likely the only way, which is why you don't use multi value fields to start with, they are exceptionally hard to deal with. Better to start with a good, normalized structure (main table and sub table).

Example of cycling through multi valued fields with code:

http://www.tek-tips.com/viewthread.cfm?qid=1657058