AnsweredAssumed Answered

Split Single Table into More Than One

Question asked by ErikChristman on Oct 13, 2011
Latest reply on Oct 13, 2011 by philmodjunk


Split Single Table into More Than One


I have a database with several thousand records all stored in one table ("Stock").  It is used for tracking inventory for a furniture store.  The fields include "Manufacturer", "Item Number", "Description", "Invoice Date", "Cost", "Customer", "Sale Date", "Selling Price", "On Floor?", "Sales Rep", "Record Number" and a few others (some calculated like "Profit Margin").

Is there a reason that this should be structured as more than one table? 

If so, can I use the data in the original table to populate the new table(s) easily?

Please also let me know if there is some online tutorial for FM that would explain some of these more basic concepts.