Data Entry Problems

  • Thread starter Thread starter Christine Ronning
  • Start date Start date
C

Christine Ronning

Hi,

I am trying to enter data into the Access structure I've created and have
many records that I am entering at once. I am trying to copy paste it
straight into the tables, but because of my relationships can only enter one
records at a time. Is there any way to change this without altering the
relationships?

Thanks Christine
 
-----Original Message-----


Hi,

I am trying to enter data into the Access structure I've created and have
many records that I am entering at once. I am trying to copy paste it
straight into the tables, but because of my
Click to expand...
relationships can only enter one
records at a time. Is there any way to change this without altering the
relationships?

Thanks Christine


.
Click to expand...

Reply,

One solution might be is:-

If you want to do this you will have to do it on a batch
basis. Make a temp table with the same fields and but
with no relationships. When you have finished entering
all your details you can append this new file, by append
query, to your old table. (Don't foget to delete the
contents of your temp table after append.)

Hope this helps

Ian
 
Back
Top