Define a new table with fields for:
• wholesale price
• wholesale price qualifier
• wholesale price unit of measure
Import the data from the existing table three times - each time from different fields.
There's no need to to replicate the description - you can leave the existing table as the parent Products table, related to the new Prices table by upc.
Thanks for your quick response. Sorry for asking the obvious. I know how to import from 1 file to another, but how do I import from 1 table to another within the same file?
Same way as from another file: select File > Import Records > File… and choose the same file as the source for the import.
Note: since the file must be open, make sure to show all records in the source table before importing.
Thank you very much. This forum is a great help!