I have a question I'm afraid I already know the answer to. I walked in on someone else's database and their fields are all in ONE HUMONGOUS table rather than parsed into several smaller ones (one per layout, at least). I am trying to find a way to rearrange the existing fields to make them easier to find, but the only solution I can come up with is to create a completely new field in the target layout, then export the data from the existing field and import it into the new one.

This would be fine, but I have approximately 300 fields to do this with. I'm told that according to database theory, the idea of just dragging a field from one table to another is strictly forboden. But is there any easier way to do this?

See:

http://fmforums.com/forum/topic/79927-creating-a-new-table-for-a-tab/page__p__372805#entry372805