On Mon, 01 Mar 2010 07:55:45 GMT, "PieterLinden via AccessMonster.com"
u49887@uwe wrote:

Dawie Theron wrote:
I need to append a number of tables.

I make use of an APPEND QUERY and it works fine.

BUT, for one part of my application, I need to work with tables which
contain multi value fields (Attachments).

I could not find a way around that. Please help

Dawie Theron

Why would you want to use multi-valued fields? Why not just create a child
table and do it the right way? I remember a looong time ago when the
FileMaker folks finally realized that MVAs were a bad idea... lots of fun to
sort out. I definitely wouldn't recommend using a feature like that.

You should have heard the meeting between MVP's and the Access development
team at the MVP summit a few years ago. Blistering... we almost got thrown
out, and I think some feelings were hurt on both sides, unfortunately.

I absolutely agree. Bad idea, bad misfeature, unnecessary and hard to work
around... but added because there was a requirement to interface with
SharePoint.
--

John W. Vinson [MVP]