Data Entry Problems

[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

 

[Ian]

-----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

relationships can only enter one

records at a time. Is there any way to change this without altering the
relationships?

Thanks Christine


.

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