Re: Projects & Contractors
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12883
interpreted = N
texte = >I'll have a database for the projects and a separate database for the >contractors. The contractor database will use a simple, sequential sku >numbering (or lettering) for each record. The project database will >include a field containing all the sku numbers of the contractors >involved with that particular project. > >How do I parse this field? Should I create individual fields to hold >each contractor, and then do an indexed search using >contractor[counter]?I think it's better to create a 3rd related database that has the project SKUs and the contractor SKUs related to each other:ProjID Contractor Proj001 AAA Proj001 BBB Proj001 EEE Proj002 AAA Proj002 GGGThis shows that Project 1 has AAA, BBB, EEE bidding on it, and Project 2 has AAA, GGG bidding on it.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>I'll have a database for the projects and a separate database for the >contractors. The contractor database will use a simple, sequential sku >numbering (or lettering) for each record. The project database will >include a field containing all the sku numbers of the contractors >involved with that particular project. > >How do I parse this field? Should I create individual fields to hold >each contractor, and then do an indexed search using >contractor[counter]?I think it's better to create a 3rd related database that has the project SKUs and the contractor SKUs related to each other:ProjID Contractor Proj001 AAA Proj001 BBB Proj001 EEE Proj002 AAA Proj002 GGGThis shows that Project 1 has AAA, BBB, EEE bidding on it, and Project 2 has AAA, GGG bidding on it.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
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:
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
RE: Signal Raised (1997)
Grepping text variable tags (was: No subject given) (2000)
ListFiles (1998)
[table] strange behaviour REAL solution (2003)
YACBQ.....(Yet another checkbox question) (2000)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
2.0 Info (1997)
[OT} DNSTrans? (2004)
problem with NT beta (1997)
WebCatalog2 Feature Feedback (1996)
WebCatalog dying in NT (1998)
Mozilla/4. and Browser Info.txt (1997)
Opposite of Summ=T? (2000)
Document Contains No Data! (1997)
Pager notification of completed orders (1998)
[WebDNA] Hmmm ... and thanks! (2008)
Customizing WebDelivery.html (1998)
Shopping Cart Problems (2000)
Re:PCS Customer submissions ? (1997)