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:
Platform Switch (1997)
redirect with frames (1997)
printing twice? and fix (1997)
Beta Documentation (1997)
HomePage Caution (1997)
Date problems (1997)
OT Spell Check (2003)
really wierd browser truncating (1997)
Another question (1997)
Cobalt (2001)
MacFinder -- a new WebDNA web site (1998)
(1997)
E-mail Attachments (1997)
WC2b15 File Corruption (1997)
Web Merchant Docs? (2002)
Running 2 two WebCatalog.acgi's (1996)
Logging purchases (1997)
Problems with emailer cutting off carriage returns (Crossplatform issue?) (1999)
ThisAutoNumber (2003)
Where is f2? (1997)