Table customer - primary key, customer id Username id Joe 1 Table orders - foreign key, customer id Customer_id product_code quantity row_id 1 2345 6 1 1 4567 9 2 3 234 3 3 Etc - any good? Paul -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Anthony Ettinger Sent: Friday, November 04, 2005 10:18 AM To: thelist at lists.evolt.org Subject: [thelist] database schema for shopping transaction Anyone have any good pointers on this? The idea is to have an online shopping cart where the customer can place multiple items (and quantities). Anthony Ettinger ph: (408) 656-2473 web: http://www.apwebdesign.com -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !