I'm looking for a VFP utility similar to FileMaker Pro's "Import Field Mapping". This consists of two columns side by side: the left column with the field names of the file being imported, the right column with the field names of the destination file. You can drag field names in the right column into alignment with their left column counterparts so that, on doing the import, values from the left field are inserted into the corresponding right field.
Ultimately, I want to be able to store particular mappings, so when I need to import a file from a known source I'll already have the mapping for it.
(I'll code this if I have to, but I'm hoping not to reinvent the wheel.)
Thanks in advance for any pointers,
-- Charlie
Charlie Hancock