I am attempting to set up a form that imports a delimited text file, allows the user to drag and drop the fields to any order, then automatically produces a query on the fly (with the fields in that order) this will be exported to a new text file.
I have designed the basics of the form, which imports the file into a table, simply Field1 - Field2 etc. (8 fields in all)
My problem is in generating the query ...
When user is finished, I currently have 8 hidden text fields containing the new field order.
So the original Field1 - Field2 - Field3 etc.
Could now be .. Field7 - Field4 - Field1
So I need to build a query on the fly, that refers to the field reference 'contained in [text1]' etc.
ie. Not select Mytable.Field1
but ... select Mytable.'Whatever field is in text1'
Or is there another way ?
I have designed the basics of the form, which imports the file into a table, simply Field1 - Field2 etc. (8 fields in all)
My problem is in generating the query ...
When user is finished, I currently have 8 hidden text fields containing the new field order.
So the original Field1 - Field2 - Field3 etc.
Could now be .. Field7 - Field4 - Field1
So I need to build a query on the fly, that refers to the field reference 'contained in [text1]' etc.
ie. Not select Mytable.Field1
but ... select Mytable.'Whatever field is in text1'
Or is there another way ?