append multi entries

  • Thread starter Thread starter Troy
  • Start date Start date
T

Troy

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
 
Troy said:
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
Click to expand...

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.
 
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.
 
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.
Click to expand...

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?
 
Back
Top