append multi entries Troy 12/23/2008 12:50:02 AM I need a way to enter data to a table, but I want a short cut. If I have more than one of a product I can enter it into the table using a text box for some sort of a multilpier. Like if I enter the number '4' in it, after I click 'Enter Data' it will enter the data from the form fields into the table total number of 4 times. Is this possible? I hope I'm clear on it. Troy

Re: append multi entries "Mike Painter" <mddotpainter[ at ]sbcglobal.net> 12/23/2008 2:18:01 AM Troy wrote: [Quoted Text] > I need a way to enter data to a table, but I want a short cut. If I > have more than one of a product I can enter it into the table using a > text box for some sort of a multilpier. Like if I enter the number > '4' in it, after I click 'Enter Data' it will enter the data from the > form fields into the table total number of 4 times. Is this > possible? I hope I'm clear on it. > > Troy Why? Normally a table would have one item and a quantity on hand rather than four repeated items. Selling would generally be the same. There might be a reason to show two or more of the same item in a form but a relational database makes you work real hard when you break it's rules.

Re: append multi entries Troy 12/23/2008 4:29:01 AM well this is the 'many' table and I may have several items that are the same. I'm using auto number as my unique number. "Mike Painter" wrote: [Quoted Text] > Troy wrote: > > I need a way to enter data to a table, but I want a short cut. If I > > have more than one of a product I can enter it into the table using a > > text box for some sort of a multilpier. Like if I enter the number > > '4' in it, after I click 'Enter Data' it will enter the data from the > > form fields into the table total number of 4 times. Is this > > possible? I hope I'm clear on it. > > > > Troy > > Why? > Normally a table would have one item and a quantity on hand rather than four > repeated items. > Selling would generally be the same. > > There might be a reason to show two or more of the same item in a form but a > relational database makes you work real hard when you break it's rules. > > >

Re: append multi entries John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/23/2008 6:49:57 AM On Mon, 22 Dec 2008 20:29:01 -0800, Troy <Troy[ at ]discussions.microsoft.com> wrote: [Quoted Text] >well this is the 'many' table and I may have several items that are the same. > I'm using auto number as my unique number. Mike's question (and mine) is: what good is it to have four items in a table which, except for a meaningless autonumber, are exactly identical? -- John W. Vinson [MVP]

Re: append multi entries boblarson 12/23/2008 8:05:01 AM And I'll add myself to that list of confused specimens. -- Bob Larson Free Tutorials and Samples at http://www.btabdevelopment.com __________________________________ "John W. Vinson" wrote: [Quoted Text] > On Mon, 22 Dec 2008 20:29:01 -0800, Troy <Troy[ at ]discussions.microsoft.com> > wrote: > > >well this is the 'many' table and I may have several items that are the same. > > I'm using auto number as my unique number. > > Mike's question (and mine) is: what good is it to have four items in a table > which, except for a meaningless autonumber, are exactly identical? > > -- > > John W. Vinson [MVP] >