Unanswered: Appending in Form and Choosing Columns
I'm having some problems and I was hoping someone could help.
I am trying to transfer data from one table to another.
My first table has columns a,b,c and my second table has columns 1,2,3
I want the user to be able to choose which column in the first table should be appended to which column in the second table.
That i'd like the user to be able to choose from a dropdown for each column in table 1, which column in table 2 it should be appended to; and then append the whole thing.
Any help would be great!!!