Table Design Question

Results 1 to 2 of 2

Thread: Table Design Question

  1. #1
    Join Date
    Dec 1969

    Default Table Design Question

    I will have several vendors selling products to several buyers. Each product will have a retail price, but may also have a special price for particular buyers -- all of whom access the site by a password.<BR><BR>So what is the best way to set up tables? I&#039;m thinking the main table with 4 fields: ProductID, Product, Description and Price. Then each buyer would have their own table with 3 fields: ProductID, Price and Password.<BR><BR>Any better ideas?

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default hmmmm

    the prod "seems" ok<BR><BR>then you will need a buyer table to get all his details and them have SEPERATE table for prodbuyer where you will have the buyerid and prod id associater to a price. That way if there is a special price you get it from that table.<BR><BR>thin this will be ok.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts