Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by innovations2
-
Flat Shipping Rates
Great! You really spurned me on and put me in the right direction. Thank you very much! -Aaron- innovations2
- Post #5
- Forum: Microsoft: Access Tables and Relationships
-
Flat Shipping Rates
I'm a little intimadated now... I'm not familiar upper and lower bounderies. Are you saying that I should have the following table structure: tblShippingRates ===================== rate_ID (autonumber/primary) rate_Lower (min total) rate_Upper (max total) rate_Price (currency/cost of shipping)...- innovations2
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Flat Shipping Rates
What would be the best way to design a table for flat rate shipping based on order total value? The shipping rates would be something like this: From $1-20.00 = $3.50; $20.01-50.00 = 5.95; $50.01-75.00 = $7.95 etc. etc. I am designing an eCommerce website and I need to create some tables in my...- innovations2
- Thread
- Replies: 5
- Forum: Microsoft: Access Tables and Relationships
-
Help with Table Relationships for Website
Remou, I posted this same thread on another forum (http://www.tek-tips.com/viewthread.cfm?qid=1168367) before noticing that this forum is more appropriate... oops! I am surprised to find that someone on the other forum responded before anyone on this forum given that the other forum is about...- innovations2
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Help Designing Tables & Relationships
I think I'm begining to see the relationships more clearly now, I am diagraming this out and thinking of the SQL necessary for the drill-down and detail pages. Thanks! -Aaron P.S. The mp3 files are church sermons that we have recorded, so yes, this is legal... I thought about mentioning this...- innovations2
- Post #3
- Forum: Microsoft: Access Forms
-
Help with Table Relationships for Website
I am developing a ColdFusion web application and I need help designing the backend. I posted this same thread on another forum before noticing that this forum is more appropriate. Overview: I am developing a website that is centered on broadcasting live & onDemand Flash Video and mp3 files, and...- innovations2
- Thread
- Replies: 3
- Forum: Microsoft: Access Tables and Relationships
-
Help Designing Tables & Relationships
Overview: I am developing a website that is centered on broadcasting live & onDemand Flash Video and mp3 files, and then selling them on DVD, CD or download. This translates into several tables with many relationships and I am uncertain how to go about designing my database. Paticulars: I have...- innovations2
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
