Hi, my second question !, is it possible and how would I share data between two existing tables. ie: Customers Table and Orders Table.

I need to have the contents of some fields from customers and copy them to replica fields in orders. I'm very, very new to this and basically been dropped in it at te deep end.

Assistance would be very grateful.

Cheers
J#xx
(Scott Perry)
MySQL V 5.1.30.

it is possible, with a trigger, but it is a very bad idea

instead, why not use a foreign key to relate the order to the customer, and use a join query when you want to show this "shared" data