append queries records with multivalue fields
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]
|