Simple Advice on Database Design

[jwnacnud]

I have a table called PRODUCTS with the following structure:

[PRODUCTS]

ModelNumber

Title

Cost

SellPrice

There are a lot more fields but this will suffice. I enter the information into the PRODUCTS table but when I export I have issues. I export a csv file (.mer) that has the field names. I need to be able to create a separate csv file for each of the two websites I feed to. each website has a slightly different set of field names that it requires and each website does have a little bit of unique data. My question: should I make a new table for each website and then make the field names match the required field names on the website or should I keep it all in one table?

If I make separate tables (which I have done) how do I keep the records synchronized. For example, the match field will be "Model Number" and I need to make sure that each table has ALL of the same records (at least the Model Number field) as the PRODUCT table. Do I need to make a script that creates a new record in each table when a new record is created in the PRODUCTS table and then do the same when a record is deleted from the PRODUCTS table? Or is there a simpler way?

Thank you in advance.

FM7 on Windows XP (though I can use FM9 as well)

[comment]

See:

http://fmforums.com/forum/showtopic.php?tid/183442/post/235426/#235426