I shall give it a try. I know I sound like a tardo, but I am kinda new to DB management.
Thanks There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown ----- Original Message ----- From: "Bryan Love" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 11:14 AM Subject: RE: Another dealing with inventories? > You're turning an everyday problem into a show stopper. > > If the relationship is 1 to 1 between songs and clips then they should > not > be in a seperate table. Put them in the same table you won't have to > wonder > how to relate them to each other any more. > > +-----------------------------------------------+ > Bryan Love > Macromedia Certified Professional > Internet Application Developer > Database Analyst > Telecommunication Systems > [EMAIL PROTECTED] > +-----------------------------------------------+ > > "...'If there must be trouble, let it be in my day, that my child may > have > peace'..." > - Thomas Paine, The American Crisis > > > > -----Original Message----- > From: Douglas Brown [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 17, 2002 10:47 AM > To: CF-Talk > Subject: Re: Another dealing with inventories? > > > Actually maybe I know the answer, but tell me if this sounds logical. I > > have the person insert the album with the album ID and when they hit > insert, it takes them to the song clip page where I carry over the > album > ID. At that point I query the album table for the song titles > associated > with the ALBUM ID and dynamically create the form fields IE: <input > type="text" NAME="clip_#song_titleID#">. Will this help me to match > > them up? > > > > > There are two major products that come out of Berkeley: LSD and [Unix] > BSD. We don't believe this to be a coincidence. > > > > Doug Brown > ----- Original Message ----- > From: "Douglas Brown" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, January 17, 2002 10:40 AM > Subject: Another dealing with inventories? > > > > I have a form with several fields that will be filled in by someone > > adding song titles. Each song title will have a song clip(30 second > demo > > of song) Have not figured out if they should be on the same form or > not. > > I need figure out how to handle the song clip issue. > > > > I need the song clips ID to match up with the song titles ID, I have > 2 > > > seperate tables. IE: [albums] [clips] How would I go about inserting > the > > song clips to where they will match up with the song titles? > > > > Hope this made sense > > > > > > > > > > There are two major products that come out of Berkeley: LSD and > [Unix] > > > BSD. We don't believe this to be a coincidence. > > > > > > > > Doug Brown > > > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
