View Single Post
  #2  
Old March 1st, 2010, 07:55 AM posted to microsoft.public.access.queries
PieterLinden via AccessMonster.com
external usenet poster
 
Posts: 307
Default append queries records with multivalue fields

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.

--
Message posted via http://www.accessmonster.com