I am attempting to add a new lookup table for an existing table. Used the table setup and let it default to table type Paradox 7,8 & 9. When I went to restructure the original table to link the lookup field I got an error that indicated the fields could not be linked as the lookup table was a newer version.
The original table was created in dos 4.5. Currently running on version 9. I recreated the lookup table as a version Paradox 4 and attempted to restructure the original table and now get a "higher Table Level Required" error.
I am assuming I may need to convert my level 4 tables to level 7,8 & 9. I am unable to find how I would do that.
Is this the solution? Or is there something else I should be looking at.
Thanks for any help.
Greg