Michael My db design consists of three tables (at least the relevant tables), products, prodDetails, and prodFormats. The prodDetails tables is a link between the products and prodFormats tables, where products contains an autonumber key field, sku, title, and description. The prodFormats table includes an autonumber key field, and title. Finally, the prodDetail table includes the foriegnkey field for the products table, another foriegn key field for the prodFormats table, and then some additional info relevant to the product and format such as how many CD's or DVD's are in the set, the quantity available, and the price.
It looks something like the following: Product Table ========== prodID prodTitle prodDesc ProdDetails Table ============ prod_ID (foriegn key) prodformat_ID (foriegn key) prodDesc prodQty prodPrice prodIsSpecial prodSpecialPrice ProdFormats Table ============== prodformatID prodformatTitle The formats are DVD, VHS, CD, Cassette, apparrel, spanish, etc. Thanks, Aaron On 2/5/06, Michael T. Tangorre <[EMAIL PROTECTED]> wrote: > > From: Aaron Roberson [mailto:[EMAIL PROTECTED] > > Thanks Will, > > After getting the multiple values inserted I was going to > > work on getting the multiple values updated as well. I have a > > CommunityMX tutorial > > (http://www.communitymx.com/abstract.cfm?cid=E68A448AE1116988) > > in my possession about updating multiple records that I was > > going to use to implement my update CFC. However, I was > > needing something that would tell me how to get the values > > from the same form field just as with the insert. > > I will definitely take a look at your example! I am kind of > > surprised that this seems to be more complicated then I > > thought. Perhaps because linking tables is so common in db > > design that I thought these kinds of inserts and updates > > would be basic. > > What's your DB design look like? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231390 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
