Auto Add Data to a table

[Kevin G]

I have a table that I would like to occasionally add rows to. I need to add
28 rows at a time and three of the columns would all contain the same data.
If anyone needs to know or cares it's a DS3 inventory table. When I add a
new DS3 I'd like to show the DS3 ID to each of the 28 timeslots along with 2
other columns of info.

I have done this in the past but have totally forgotten how. The DS3 ID and
one other column will require user input, the third column will number 1 - 28.

Ex:

Column1 Column2 Column3
OC12.1.1(user input) 1 101/T3/LocationA/LocationB
(user input)

 

[John W. Vinson/MVP]

I have a table that I would like to occasionally add rows to. I need to
add
28 rows at a time and three of the columns would all contain the same
data.
If anyone needs to know or cares it's a DS3 inventory table. When I add a
new DS3 I'd like to show the DS3 ID to each of the 28 timeslots along with
2
other columns of info.

I have done this in the past but have totally forgotten how. The DS3 ID
and
one other column will require user input, the third column will number 1 -
28.

Ex:

Column1 Column2 Column3
OC12.1.1(user input) 1
101/T3/LocationA/LocationB
(user input)

You could have a handy little utility table - mine is named Num with one
Long Integer field N, with values from 1 through 10000 or so. You could run
an Append query based on Num with a criterion <= 28 on N, using form
references for the user input fields.

I'm not keen on your Column3 - does it violate the principle that fields
should be atomic? Each field should have only one piece of information, and
this looks like it has four, including an embedded one to many relationship!

 

[Kevin G]

You could have a handy little utility table - mine is named Num with one
Long Integer field N, with values from 1 through 10000 or so. You could run
an Append query based on Num with a criterion <= 28 on N, using form
references for the user input fields.

I'm not keen on your Column3 - does it violate the principle that fields
should be atomic? Each field should have only one piece of information, and
this looks like it has four, including an embedded one to many relationship!



Column 3 is actually a circuit ID for a DS3. It's not different information it's all one piece of info.