Modify existing table for more details?
in [Tables]
|
Prev: Test
Next: Remote control of tabls
From: Shannon on 24 Feb 2010 17:24 On Feb 23, 4:16 pm, KARL DEWEY <KARLDE...(a)discussions.microsoft.com> wrote: > It seems to me you do not need another table as your tblBidDet.Location is > not a true location but a text description using a lookup of common names > ffor areas. > > I would just add a Size field. > > -- > Build a little, test a little. > > > > "Shannon" wrote: > > On Feb 23, 1:05 pm, KARL DEWEY <KARLDE...(a)discussions.microsoft.com> > > wrote: > > > >>I assume I need to split the Location field into its own table > > > > You did not say how your table(s) is structured now - field names with > > > datatype or provide sample data. > > > How will you use the Size? Will you be adding or multiplying by some other > > > factors? > > > > >>How would I go about correcting the existing estimates that have no location sizes entered. > > > > Not knowing the above I would guess to set all old records = 0. > > > > -- > > > Build a little, test a little. > > > > "Shannon" wrote: > > > > I have a table of estimates. Each estimate can have multiple locations > > > > stored as a text field. New need: I want to store the sizes of each > > > > location. Example is -Old method: EstNo= 200 which has Location = > > > > bedroom, Location= Family room. New need is: EstNo 200, Location > > > > = bedroom with Size= 100 and Location= Family room size = 125. I > > > > assume I need to split the Location field into its own table with a > > > > Location ID field, Location field, location size field and EstNo > > > > field. Also, How would I go about correcting the existing estimates > > > > that have no location sizes entered. Hope I discribed this clearly > > > > as I am a newby. > > > > .- Hide quoted text - > > > > - Show quoted text - > > > Thanks for the response and here is the info requested. > > tblBidInfo > > EstNo=number > > Descrip=txt > > JobCatId= lookup table txt > > Other misc fields > > > tblBidDet > > BidId= autonum > > EstNo-=number ~ linked to tblBidInfo > > Location= txt values recvd from lookup table > > Other misc fields > > > I was thinking I need to add a new tblLocations with the following > > fields, > > LocId = autonum > > LocName = txt ~ recvd from exisitng Lookup table of txt listings > > > I get confused here. > > I will be using Location size in simple math calcs. Basically Estno > > 2010.1 has a bedroom thats 100 sf. All the listed work in that > > location will be reported and then calculated on the size [ bedroom > > work costs 8,000 / 100 sf = 80 psf cost. There are other calcs and > > percentage operations I will do in reports based upon that data.] > > > Again, thanks for you input. > > Shannon > > > .- Hide quoted text - > > - Show quoted text - To Karl: I believe that I must move the Location field to it's own table for this example. Estno 200 can have a bedroom thats 100 sf. EstNo 201 can have a bedroom thats 175 sf. So, my logic is One Estimate can have many locations[rooms lets say] of differant sizes. Another Estimate might have the same location name, but differant sizes. To Steve: I will try your suggestion. Is it ok to post a pdf of the relationship window once I get it how I think it should be?
From: KARL DEWEY on 24 Feb 2010 19:33 You would have two tables in a one-to-many relationship. The first for the basic bib information -- BidID - primary key Client - Bid - $'s Bid_Date etc. BidComponents -- BidCompID - primary key BidID - foreign key Location - Size - etc. And possibly a third table -- BidCompMaterial -- BidCompMatID - primary key BidCompID - foreign key Material - Cost - Labor - etc. -- Build a little, test a little. "Shannon" wrote: > On Feb 23, 4:16 pm, KARL DEWEY <KARLDE...(a)discussions.microsoft.com> > wrote: > > It seems to me you do not need another table as your tblBidDet.Location is > > not a true location but a text description using a lookup of common names > > ffor areas. > > > > I would just add a Size field. > > > > -- > > Build a little, test a little. > > > > > > > > "Shannon" wrote: > > > On Feb 23, 1:05 pm, KARL DEWEY <KARLDE...(a)discussions.microsoft.com> > > > wrote: > > > > >>I assume I need to split the Location field into its own table > > > > > > You did not say how your table(s) is structured now - field names with > > > > datatype or provide sample data. > > > > How will you use the Size? Will you be adding or multiplying by some other > > > > factors? > > > > > > >>How would I go about correcting the existing estimates that have no location sizes entered. > > > > > > Not knowing the above I would guess to set all old records = 0. > > > > > > -- > > > > Build a little, test a little. > > > > > > "Shannon" wrote: > > > > > I have a table of estimates. Each estimate can have multiple locations > > > > > stored as a text field. New need: I want to store the sizes of each > > > > > location. Example is -Old method: EstNo= 200 which has Location = > > > > > bedroom, Location= Family room. New need is: EstNo 200, Location > > > > > = bedroom with Size= 100 and Location= Family room size = 125. I > > > > > assume I need to split the Location field into its own table with a > > > > > Location ID field, Location field, location size field and EstNo > > > > > field. Also, How would I go about correcting the existing estimates > > > > > that have no location sizes entered. Hope I discribed this clearly > > > > > as I am a newby. > > > > > .- Hide quoted text - > > > > > > - Show quoted text - > > > > > Thanks for the response and here is the info requested. > > > tblBidInfo > > > EstNo=number > > > Descrip=txt > > > JobCatId= lookup table txt > > > Other misc fields > > > > > tblBidDet > > > BidId= autonum > > > EstNo-=number ~ linked to tblBidInfo > > > Location= txt values recvd from lookup table > > > Other misc fields > > > > > I was thinking I need to add a new tblLocations with the following > > > fields, > > > LocId = autonum > > > LocName = txt ~ recvd from exisitng Lookup table of txt listings > > > > > I get confused here. > > > I will be using Location size in simple math calcs. Basically Estno > > > 2010.1 has a bedroom thats 100 sf. All the listed work in that > > > location will be reported and then calculated on the size [ bedroom > > > work costs 8,000 / 100 sf = 80 psf cost. There are other calcs and > > > percentage operations I will do in reports based upon that data.] > > > > > Again, thanks for you input. > > > Shannon > > > > > .- Hide quoted text - > > > > - Show quoted text - > > To Karl: I believe that I must move the Location field to it's own > table for this example. Estno 200 can have a bedroom thats 100 sf. > EstNo 201 can have a bedroom thats 175 sf. So, my logic is One > Estimate can have many locations[rooms lets say] of differant sizes. > Another Estimate might have the same location name, but differant > sizes. > > To Steve: I will try your suggestion. > > Is it ok to post a pdf of the relationship window once I get it how I > think it should be? > . >
From: Steve on 25 Feb 2010 12:28 Yes, I will be glad to look at it! Steve "Shannon" <shannon.nelms(a)gmail.com> wrote in message news:523dcf88-38a0-48bf-beea-efd206fe4b7e(a)g8g2000pri.googlegroups.com... On Feb 23, 4:16 pm, KARL DEWEY <KARLDE...(a)discussions.microsoft.com> wrote: > It seems to me you do not need another table as your tblBidDet.Location is > not a true location but a text description using a lookup of common names > ffor areas. > > I would just add a Size field. > > -- > Build a little, test a little. > > > > "Shannon" wrote: > > On Feb 23, 1:05 pm, KARL DEWEY <KARLDE...(a)discussions.microsoft.com> > > wrote: > > > >>I assume I need to split the Location field into its own table > > > > You did not say how your table(s) is structured now - field names with > > > datatype or provide sample data. > > > How will you use the Size? Will you be adding or multiplying by some > > > other > > > factors? > > > > >>How would I go about correcting the existing estimates that have no > > > >>location sizes entered. > > > > Not knowing the above I would guess to set all old records = 0. > > > > -- > > > Build a little, test a little. > > > > "Shannon" wrote: > > > > I have a table of estimates. Each estimate can have multiple > > > > locations > > > > stored as a text field. New need: I want to store the sizes of each > > > > location. Example is -Old method: EstNo= 200 which has Location = > > > > bedroom, Location= Family room. New need is: EstNo 200, Location > > > > = bedroom with Size= 100 and Location= Family room size = 125. I > > > > assume I need to split the Location field into its own table with a > > > > Location ID field, Location field, location size field and EstNo > > > > field. Also, How would I go about correcting the existing estimates > > > > that have no location sizes entered. Hope I discribed this clearly > > > > as I am a newby. > > > > .- Hide quoted text - > > > > - Show quoted text - > > > Thanks for the response and here is the info requested. > > tblBidInfo > > EstNo=number > > Descrip=txt > > JobCatId= lookup table txt > > Other misc fields > > > tblBidDet > > BidId= autonum > > EstNo-=number ~ linked to tblBidInfo > > Location= txt values recvd from lookup table > > Other misc fields > > > I was thinking I need to add a new tblLocations with the following > > fields, > > LocId = autonum > > LocName = txt ~ recvd from exisitng Lookup table of txt listings > > > I get confused here. > > I will be using Location size in simple math calcs. Basically Estno > > 2010.1 has a bedroom thats 100 sf. All the listed work in that > > location will be reported and then calculated on the size [ bedroom > > work costs 8,000 / 100 sf = 80 psf cost. There are other calcs and > > percentage operations I will do in reports based upon that data.] > > > Again, thanks for you input. > > Shannon > > > .- Hide quoted text - > > - Show quoted text - To Karl: I believe that I must move the Location field to it's own table for this example. Estno 200 can have a bedroom thats 100 sf. EstNo 201 can have a bedroom thats 175 sf. So, my logic is One Estimate can have many locations[rooms lets say] of differant sizes. Another Estimate might have the same location name, but differant sizes. To Steve: I will try your suggestion. Is it ok to post a pdf of the relationship window once I get it how I think it should be?
From: John... Visio MVP on 25 Feb 2010 12:36 "Steve" <notmyemail(a)address.com> wrote in message news:%23Y4Uj$jtKHA.6124(a)TK2MSFTNGP04.phx.gbl... > Yes, I will be glad to look at it! > > Steve For how much are you offering your questionable services?
From: Stop$teve on 25 Feb 2010 18:46
"Steve" <notmyemail(a)address.com> schreef in bericht news:%23Y4Uj$jtKHA.6124(a)TK2MSFTNGP04.phx.gbl... > Yes, I will be glad to look at it! > > Steve Amazing... but I guess the bill comes later ?? -- Get lost $teve. Go away... far away.... No-one wants you here... no-one needs you here... OP look at http://home.tiscali.nl/arracom/whoissteve.html (Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!) For those who don't 'agree' with this mail , because $teve was 'helping' with his post... We warned him a thousand times... Sad, but he is not willing to stop advertising... He is just toying with these groups... advertising like hell... on and on... for years... oh yes... and sometimes he answers questions... indeed... and sometimes good souls here give him credit for that... ==> We are totally 'finished' with $teve now... ==> Killfile 'Stop$teve' and you won't see these mails.... Arno R |