Appending a table with Multivalued Fields in 2007

[Jared]

I have database that tracks vehicle servicing with an attachment field to
store pdf's of invoices and photo's of any repairs made.

Access 07 won't allow me to append an attachment field from a table to
another and I' like to split the attachments out to a separate db file
altogether as they are a pain to deal with any time I need to modify the
schema.

Any suggestions?

 

[Larry Daugherty]

Avoid the manufactured issue of the phony "multivalued fields" by
treating each of them as exactly what it is: a Related (child) table
wherein each of those values is a separate record in the related
table.

HTH

 

[Jared]

Thanks Larry,

Unfortunately I didn't realise the issues with these fields during intitial
implementation and now have a few hundred records to deal with.

I have however found a work around.

I copied the original table "service". In the original table I deleted the
attachments field. In the copy I deleted all fields excpet the attachment and
the primary key. This primary key is now the foreign key for the original
table.

I've now split the 2nd table into a separate be.

Jared

 

[JLPerez]

Hi. I have a similar problem but how do you program that from a "lookup"
table you can append a field with multiple values from that lookup table. In
other words, how do you program what the "manufactured" multivalued fields"
does without the need to redo everything.
Thanks

 

[Jeff Boyce]

I'm not quite following what you're trying to do...

Are you saying you want what a multivalued field can do, but don't want to
use the Access multivalued field data type and don't want to recreate its
functionality the "old-fashioned way"? If so, that sounds like a "Hollywood
computer" (press a button and solve world hunger)<G>!

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP