We help IT Professionals succeed at work.
Get Started

Adding Multiple Records with same information

112 Views
Last Modified: 2016-01-02
Hello,

I would like to see if I could add multiple records with some information that is the same throughout the table.

What I would like to do is have some fields that would repeat the information and fields that have a "through" would be unique...example below:

Field1: 1
through
Field2: 10
Field3: John
Field4: Doe
Field5: (111)123-1234
Field6: Blue Visitor

so it would be:  Enter the Batch of Cards Issued:  1   THROUGH    10
or someone could enter:                                         1   THROUGH   1

Field's 3-6 are the same that would repeat in the records.

so I would like it to enter separate records...if 1 through 10 (so it would be 10 records entered) or if the person entered the same info:  11  THROUGH 11 then there would only be 1 record entered
so the Table would be setup

for the multiple entries you would have multiple entries:
Field1: 1
Field2: John
Field3: Doe
Field4: 1111231234
Field5: Blue Visitor

Field1: 2
Field2: John
Field3: Doe
Field4: 1111231234
Field5: Blue Visitor

Field1: 3
Field2: John
Field3: Doe
Field4: 1111231234
Field5: Blue Visitor
.
ect...

so for the single record you would have 1 entry in the table:

Field1: 11
Field2: John
Field3: Doe
Field4: 1111231234
Field5: Blue Visitor

ect....

don't know if I could do this with VB and how could I do this?  this is also thinking ahead but the same concept would be if I wanted to return those cards, I would have a similar process that would enter a separate field that would show it returned and repeat it also....
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE