Creating a backup record from an original record

J

Jazz57

Good afternoon everyone

I have a form where i write all the information that i need for a specific
record

the primary key of my table is the field Movimento (sequential Number - not
Auto)

I need to make a backup of a specific record (for example : movimento = 5 )
from employee number 100 to another employee 200, or three more employes,
for instance employees 300,400,500.

As the first table has a lot of data to be filled i am trying this way in
order to not waste so many time.

What i thought is a new form with all the information where i have 5 more
fields to put the new Movimento (Key) and the new employees

the rest of the information is the same , so i just have to to copy to a new
record.

Example:

Original:

Movimento 5 Employee 100

Backup to:

Movimento 6 Employee 200
Movimento 7 Employee 300
Movimento 8 Employee 400
Movimento 9 Employee 500
Movimento 10 Employee 600

Q1: Is this possible to do with a new form like i am trying ? Should i use
instead a query update ?

Q2: i am having some problems with the form and the data because it simply
does not write new records. Maybe because it does not allow to change the
key....


Could anybodu help me ...

Would appreciate any kind of help

Thanks in advance
 
N

NevilleT

Sounds like it is more a database design problem. Can you use a table that
lists Movimento and Employee number to link the data?
 
J

Jazz57

Good morning

Both field Movimento and Employee are in the same table

So, this is just a facility to the user in order to does not have to write
the five records again, when it just changes the number of the employee.

Thanks for your help


--
Adriano Santos



"NevilleT" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top