Can I move a field from one table to another?

[Macette]

I'm a web developer, and I'm pretty unfamiliar with FM these days (I used it in my old job, way back on version 5)...

A client of mine has a database with a single table, and I'm of the view that the information would be better divided into two tables. Is it possible for me to create a new table in the database, and then move some of the existing fields into it?

[aaa]

Hi, Maccete!

I think that, you must create this fields in the second table, then import data from first.

[Lee Smith]

In [color:blue]Advance, not sure about the [color:blue]Standard Edition, you can copy fields between Table Occurances ([color:blue]TO)

Once you have copied the fields over to the New [color:blue]TO, you will need to import the data as [color:red]aaa has suggested, and then you can just delete them from the Old [color:blue]TO.

If you are meaning Tables, as in a [color:blue]Table Layout, let me know.

HTH

Lee

[comment]

In version 8 (any flavor), you can import the table into a NEW table in the same file. This will create a duplicate of the table, and you can then delete the unused fields from each table.

[Lee Smith]

I thought you could do this, but I wasn't positive since I don't use the Standard Edition.

Duplicating the TO is a good suggestion.

Lee