Creating a backup record from an original record

  • Thread starter Thread starter Jazz57
  • Start date Start date
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
 
Sounds like it is more a database design problem. Can you use a table that
lists Movimento and Employee number to link the data?
 
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:
 
Back
Top