If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Appending a table with Multivalued Fields in 2007
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? |
#2
|
|||
|
|||
Appending a table with Multivalued Fields in 2007
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 -- -Larry- -- "Jared" wrote in message ... 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? |
#3
|
|||
|
|||
Appending a table with Multivalued Fields in 2007
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 "Larry Daugherty" wrote: 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 -- -Larry- -- "Jared" wrote in message ... 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? |
#4
|
|||
|
|||
Appending a table with Multivalued Fields in 2007
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 "Larry Daugherty" wrote: 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 -- -Larry- -- "Jared" wrote in message ... 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? |
#5
|
|||
|
|||
Appending a table with Multivalued Fields in 2007
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 "JLPerez" wrote in message ... 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 "Larry Daugherty" wrote: 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 -- -Larry- -- "Jared" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|