If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Auto Add Data to a table
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) |
#2
|
|||
|
|||
Auto Add Data to a table
"Kevin G" wrote in message ... 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! |
#3
|
|||
|
|||
Auto Add Data to a table
"John W. Vinson/MVP" wrote: "Kevin G" wrote in message ... 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! Column 3 is actually a circuit ID for a DS3. It's not different information it's all one piece of info. |
Thread Tools | |
Display Modes | |
|
|