Re: many-to-one problem
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17143
interpreted = N
texte = At 13:05 Uhr -1000 20.04.1998, Kenneth Grome wrote:>>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? Ok, I should improve my english...One company. One productlist, the pool. 50 trusted clients are allowed to buy online. Not all clients can buy all products. Not all clients should see all products. Each client logs in with a password ...and gets his own price-list... ...for his preconfigured selection of products. ...and than he should walk around like in a common shop, controlled by his access privilegues.In fact I try to port a 4D database to Webcat. There are 250 users now, all working with just 2 different pricelists. Now things will change, we will get additional pricelists with less users per list. The old database would need some improvements, now I try to find out if it can be quickly rewritten in WebCat ;-) Peter__________________________________________ Peter Ostry Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-877 74 54 fax ++43-1-877 74 54 po@ostry.com _______________ www.ostry.com
Associated Messages, from the most recent to the oldest:
At 13:05 Uhr -1000 20.04.1998, Kenneth Grome wrote:>>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? Ok, I should improve my english...One company. One productlist, the pool. 50 trusted clients are allowed to buy online. Not all clients can buy all products. Not all clients should see all products. Each client logs in with a password ...and gets his own price-list... ...for his preconfigured selection of products. ...and than he should walk around like in a common shop, controlled by his access privilegues.In fact I try to port a 4D database to Webcat. There are 250 users now, all working with just 2 different pricelists. Now things will change, we will get additional pricelists with less users per list. The old database would need some improvements, now I try to find out if it can be quickly rewritten in WebCat ;-) Peter__________________________________________ Peter Ostry Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-877 74 54 fax ++43-1-877 74 54 po@ostry.com _______________ www.ostry.com
Peter Ostry
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:
WebCat b13 CGI -shownext- (1997)
emailer error -108 (1997)
Signal Raised (1997)
WebCat2 several catalogs? (1997)
Problems searching from a FORM (1997)
truncating email part II (1997)
[Sum] function? (1997)
can WC render sites out? (1997)
Search design (1997)
autocommit problem (1998)
Running 2 two WebCatalog.acgi's (1996)
Format of Required fields error message (1997)
Mac app. that converts e-mails (2000)
Looking for 5 to 12 shops with 3 URLs & statements (1997)
problems with 2 tags (1997)
attacment pdf (2001)
Signal Raised (1997)
More DateMath problems (1997)
[ListFiles] & [loop] (1998)
Formatting dates stored in db (2003)