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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>>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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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)