From getting a bunch of file-names, 9000, into a databases has been a long journey, but I'm there. Now with my limited knowledge of Access I need take a field, holding image file-names, and the name into a matching field in a different table as an attachment.
Both table's share the same name,wi. Table "A" retains a field "wi" that has a value I want in table "B". I created an attachment field in table B, which will hold the table "A" "WI" value. Attachment field called "WI-Image".
Table "A" will not have a value for every table "B". So many of table "B" attachment field will not get a value because of the lack of a value in table B.
Also table "A" will have values that are not in table "B".
Table "A" = Table "B" (move "A"-> to "B" attachment field).
Table "A" has no record in table "B" (Create Record in Table "B" and add). Fiwld called "WI will get the value that is in "A"->WI
Bob
Both table's share the same name,wi. Table "A" retains a field "wi" that has a value I want in table "B". I created an attachment field in table B, which will hold the table "A" "WI" value. Attachment field called "WI-Image".
Table "A" will not have a value for every table "B". So many of table "B" attachment field will not get a value because of the lack of a value in table B.
Also table "A" will have values that are not in table "B".
Table "A" = Table "B" (move "A"-> to "B" attachment field).
Table "A" has no record in table "B" (Create Record in Table "B" and add). Fiwld called "WI will get the value that is in "A"->WI
Bob
