I need to make a copy of a table's structure within the same file. I am making archive tables to cut down on the number of records normally seen by a user in day to day use. I don't want to have to totally redefine the tables if I don't have to.

I am assuming that I will have to make an odbc connection to the file and use SQL to copy the table somehow, but since there isn't a supported Copy function in the documentation, that makes it hard.

Has anyone solved this type of problem that could give me a point in the right direction and save me some all too precious hours?

John -

Look at FMRobot by New Millennium (www.nmci.com)

Unfortunately FileMaker 7 does not include a native function to duplicate tables (yet)

Why not put the archive tables in another file? Make a clone and modify it.

I was trying to minimize the number of files to simplify the security setup. It just seemed like there ought to be a way to pull it off with the parts of SQL that are supported, but maybe not.

I wasn't looking to automatically convert much of this solution, so I was not looking at purchasing anything to do it for me, just trolling for a ready made solution.