Does a job have multiple locations? if so, you need a separate child table for the locations. If not, you can have job info and location info in the same table and your data structure would be:
Parts part id other part fields Jobs job id location other job info PartsJobs part id jobi id If a job has multiple locations, your data structure would be Parts part id other part fields Jobs job id other job info Location location id part id job id other location info PartsLocation part id location id installed date other info related to specific part and location On 6/12/06, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > hey now! Don't diss my beloved underscores. They're on the keyboard > for a reason! Actually, I've taken a liking to the way you name stuff > in ruby and that's a bleedover. > > Back to the problem at hand....First off this was an access database > that was originally all in one table :) I've split it out into 6 so > far. The job table has info about a job (fire alarm systems), > including job #, start date, end date ,blah blah blah. I forgot that > I had split out the location earlier, so it's no longer in the jobs > table. So the table I'm trying to name contains a reference to the > job id, part id, and quantity. I'm still having a brain lock trying > to figure out what to call this thing....sounds stupid huh? I almost > think I need to rename the 'parts' table to 'catalog' and then have > the name 'parts' for the table in question. > > > > > On 6/12/06, deadcityskin <[EMAIL PROTECTED]> wrote: > > I happen to hate the accursed underscore, and only used it to conform to his > > naming convention. > > > > Great choice :) > > > > > -----Original Message----- > > > From: Duane [mailto:[EMAIL PROTECTED] > > > Sent: Monday, June 12, 2006 7:02 PM > > > To: CF-Community > > > Subject: RE: stupid table name question > > > > > > > > > Depends on your naming conventions but I would use PartLocation > > > > > > Duane > > > > > > > -----Original Message----- > > > > From: Zaphod Beeblebrox [mailto:[EMAIL PROTECTED] > > > > Sent: Monday, June 12, 2006 6:09 PM > > > > To: CF-Community > > > > Subject: stupid table name question > > > > > > > > > > > > I'm having a brain fart naming some tables. I've got a "job" table > > > > with details about the location at which the equipment is installed. > > > > I've got a "parts" table that lists all the parts that can be > > > > installed at a location. Now, I can't figure out what to call the 3rd > > > > table. "Installed_parts" ? That seems weird to me for some reason. > > > > > > > > zb > > > > > > > > > > > > -- > > > > No phone can take your place > > > > You know what I mean > > > > We have the same intrigue > > > > As a court of kings > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:209002 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
