Re: many-to-one problem

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17138
interpreted = N
texte = >>>I need one main-database for >>>SKU, ProductID, Category, Type, Description, HasPhoto, Photo, >>>and many databases (one for each client) with >>>SKU, ProductID, ItemPrice, Unit, UnitPrice. >> >>>If I put all stuff in one database I would get up to 200 fields. >> >>Seems to me that you would have only 5 fields -- the original 4 plus a new >>field named clientID, which would be used to identify which client each >>record belongs to ... > >No, there are 1000 products and each client has a selection of them and his >own pricing which depends on special agreements.So basically YOU'RE the one with the master list of products, and you're letting your clients sell some of those products -- from their own online stores -- and that's why you need a separate database for each client?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: many-to-one problem (Kenneth Grome 1998)
  2. Re: many-to-one problem (Peter Ostry 1998)
  3. Re: many-to-one problem (PCS Technical Support 1998)
  4. Re: many-to-one problem (Kenneth Grome 1998)
  5. Re: many-to-one problem (Peter Ostry 1998)
  6. Re: many-to-one problem (Kenneth Grome 1998)
  7. Re: many-to-one problem (Peter Ostry 1998)
  8. Re: many-to-one problem (Kenneth Grome 1998)
  9. Re: many-to-one problem (Peter Ostry 1998)
  10. Re: many-to-one problem (Kenneth Grome 1998)
  11. many-to-one problem (Peter Ostry 1998)
>>>I need one main-database for >>>SKU, ProductID, Category, Type, Description, HasPhoto, Photo, >>>and many databases (one for each client) with >>>SKU, ProductID, ItemPrice, Unit, UnitPrice. >> >>>If I put all stuff in one database I would get up to 200 fields. >> >>Seems to me that you would have only 5 fields -- the original 4 plus a new >>field named clientID, which would be used to identify which client each >>record belongs to ... > >No, there are 1000 products and each client has a selection of them and his >own pricing which depends on special agreements.So basically YOU'RE the one with the master list of products, and you're letting your clients sell some of those products -- from their own online stores -- and that's why you need a separate database for each client?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

transferring values (1998) Assigning new CART number (1997) Re:Searching for ALL / empty form field (1997) textarea inputs and returns (1999) Error:Too many nested [xxx] contexts (1997) Next X hits (1996) RE: Cookies? (1997) [WebDNA] [Convertwords] (2009) [WebDNA] IIS 7.5 (2015) date range (1998) Sensations (1997) help with duplicate records posted (1998) More NT encyption!! (1999) Move WebDNA DB to MySQL (2005) [TaxableTotal] - not working with AOL and IE (1997) [append] (1997) Multiple Replaces? (1997) anyone using Webcat 4.x in production? (2000) Help! WebCat2 bug (1997) Showing unopened cart (1997)