Hi everybody,

As follows:

I have a table which has a bad database design. I want to have the layout and informations of that table in two seperated tables. So i want to export the existing one to two another table and there i want to import all the existing information and some fields.So anyone a suggeston how should i do that?

Thankx,

Sima

Nobody can helps me???

It's not clear if you're trying to do this in FM6 (as your profile indicates) or in FM7 (as your use of "tables" implies). FM6 databases only have one table and are usually referred to as "files".

In FM6, there is no way to copy the schema (fields and relationships) from file to file, but you could Save a Copy as a Clone, adjust the fields in the new file, then import the data from the original into the desired fields. To move layouts, simply copy all the elements from the old file to a new blank layout in the new file.

In FM7, there is still no built-in way to copy the schema between tables, but there is a 3rd party tool from New Millenium called FMRobot that can do some of this.

http://www.newmillennium.com/

I'm doing it in filemaker 6 but i have learned databases in the terms of tables and rows so that's why..

My problem is that i want to define something to keep the relation between paper and journalist which are in one table now and i want to sepreat them afterwards to two apart tables but i have to know which journalist is working with which paper first and then transform the tables...

i have now 10 times one paper and all the informations if there work 10 people.

Any idea to solve this problem?

Thnakx,

Sima