I am trying to use an Insert query to add the fields from table A to existing table B. Table A was imported from Cardscan, which for no sensible reason places phone numbers in any of about twelve fields.
Rather than practice more on the "changeto" method (using that to adjust the source table to one field for each destination field) I thought I would follow instructions in a QUE quide which read:
"Use example elements to connect each field in the source table to the destination table. To change the example element, click the Join Tables button on the SpeedBar (I am working on that..may be my problem.) *If you want to combine two fields from the source table (Cardscan) in to one field in the destination table (Roladex), (I do) use + to connect the examle elements in the destination field."
WHERE!!!????? Where does the benighted + belong???? before? after? with a space? a coma? somewhere entirely different? WHERE for the love of Mike are you supposed to put the thing?
OK, rant over. specifics: Nothing works.
If I just put example elements in any two fields I get an empty Insert table.
I have one Name field in each DB. My entry should be
Roladex: join1, Name
Cardscan: join1, Name (Name being an example element)
(what am I doing wrong. Error: A field cannot contain more than one element to be inserted, but otherwise the Inserted table is empty).
I have One PHONE element in the destination table (Roladex) and need to combine about five in the source table (Cardscan).
Forgetting the join issue for a moment, Roladex reads (F5)Phone+ (OR +(F5)Phone ?)(syntax error) and all of the files to be included from Cardscan read (F5)Phone (Syntax Error)
Or Roladex|Phone (destination) Phone contains Example element Phone and Cardscan|phone1 , Cardscan|phone2 etc contain Example element Phone+ or +Phone ...(syntax error).
So...what am I doing wrong..or, to make things easier, what right? What do I do with the ^%$##%& +, if anything (Without it there is an empty table..and with it probably too.) Join don't do it for the tables.
Gracias.
(Once this is done I'll make a backup of the miracle table - and try the case changing magic script).
Rather than practice more on the "changeto" method (using that to adjust the source table to one field for each destination field) I thought I would follow instructions in a QUE quide which read:
"Use example elements to connect each field in the source table to the destination table. To change the example element, click the Join Tables button on the SpeedBar (I am working on that..may be my problem.) *If you want to combine two fields from the source table (Cardscan) in to one field in the destination table (Roladex), (I do) use + to connect the examle elements in the destination field."
WHERE!!!????? Where does the benighted + belong???? before? after? with a space? a coma? somewhere entirely different? WHERE for the love of Mike are you supposed to put the thing?
OK, rant over. specifics: Nothing works.
If I just put example elements in any two fields I get an empty Insert table.
I have one Name field in each DB. My entry should be
Roladex: join1, Name
Cardscan: join1, Name (Name being an example element)
(what am I doing wrong. Error: A field cannot contain more than one element to be inserted, but otherwise the Inserted table is empty).
I have One PHONE element in the destination table (Roladex) and need to combine about five in the source table (Cardscan).
Forgetting the join issue for a moment, Roladex reads (F5)Phone+ (OR +(F5)Phone ?)(syntax error) and all of the files to be included from Cardscan read (F5)Phone (Syntax Error)
Or Roladex|Phone (destination) Phone contains Example element Phone and Cardscan|phone1 , Cardscan|phone2 etc contain Example element Phone+ or +Phone ...(syntax error).
So...what am I doing wrong..or, to make things easier, what right? What do I do with the ^%$##%& +, if anything (Without it there is an empty table..and with it probably too.) Join don't do it for the tables.
Gracias.
(Once this is done I'll make a backup of the miracle table - and try the case changing magic script).
