Solution 1

Steps:

1. Open the database that you want to take the lookup table from. Note the field to which the lookup is attached.
   
   
2. Go to (Options / Utilities / Create or Modify Forms), Select (File / Close Form) and you will get a blank screen, at which point you should select (Options / Show System Tables). This will enable you to have access to the internal tables, such as the lookup tables.
   
   
3. Choose (File / Open Form / New). At this point, you will be prompted for a form name. It is strongly suggested that you give the form the same name as the lookup table you will be exporting.
   
   
4. You will now be asked if you want to attach the form to an existing table or create a new table, and you will see the lookup tables in the table list. Their names are proceeded by underscores. Choose the lookup you want to export. You will then see a blank form with the name of the lookup table. Click once on the ‘ab’ box in Tools, and click again on the blank form, and double click on codecol, adding it to the form.
   
   
5. You can now exit the Form Editor, saving your changes. Go to File/Select Form and choose your new lookup form. This will take you back to the Main Window.
   
   
6. Open the database in column display by double clicking on it. Click on Fields and display the Codecol and the Expansion Column by dragging them out.
   
   
7. Select File/Write Summaries. Deselect Ascii Text by clicking on Comma Separated. Deselect Write Column Headings. Close the command box.
   
   
8. Click on the blue diskette next to the printer in the toolbar, and save your export. The best idea is to save it with the same name as the lookup, with .txt as the extension, i.e. ‘issues.txt’.
   
   
9. Open the target case. Go to the forms editor and create the same form, following steps 2, 3, 4, and 5 above. When you return to the utilities screen, choose Import Summaries.
   
   
10. Select the Text file you created before as the import file. You should see codecol and the name of the expansion column in the field list. Select them and go to setup. Make sure you are setup to start the import at row 1 and that you do not reserve the 1^st row for column headings.
    
    
11. Go back to the main import menu screen and do a full check. You should not have any errors if these steps have been followed exactly. Then you can import your lookup table.
    
    
12. Go back to the Form Editor and attach the lookup table to the field by following the instructions in the lookup table wizard.