Copying Related Data In Datasheet View

[Jim Mac Millan]

I decided to move some information from one area in my database to another.
While I was viewing the datasheet I right clicked on the record and chose
cut. A message popped up warning that...

"Relationships that specify cascading deletes are about to cause 1 record(s)
in this table and in related tables to be deleted"

Out of curiosity I clicked on yes then proceeded to paste the data into the
new area. When I viewed the data the related information did not follow. I
went back and copied instead and upon pasting it the data still did not
follow. Fortunately I always back up before doing anything of this nature.
My question? is there any way to copy a record and its related data to
another area in Datasheet view?

TIA
Jim Mac Millan

 

[Guest]

Jim, as a good practice and for a variety of reasons such as what you
experienced, you should NOT edit a table directly.

To move data, use Update and Append queries.

 

[Roger Carlson]

I'm still confused about the "move some information from one area in my
database to another". It sounds like you might have some database design
problems. Why would you want to do this?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jim Mac Millan]

Hi Roger,

I have three tables linked like so.

Batch_Control (1 - ?) Leads_List (1 - ?) Leads_Notes

Each week I start a new batch of leads. In the Batch_Control table the
following fields ID, Date, Batch_No (note ID & Batch_No is unique)

In the Leads_List table I have ID, Link_To_Batch_Control, SIC, NAIC,
along with other fields that contain contact information.

In the Leads_Notes table I have Link_To_Leads, Date, Time, and Notes.

Occasionally I'll need to more the information tied to say batch 2 moved
over to batch 6.

Does that make sense?
Jim Mac Millan

 

[Jim Mac Millan]

Strange, what you see as question marks where meant to be infinity symbols.
I guess the extended characters don't work with e-mail?

Jim Mac Millan

 

[Roger Carlson]

Then why not chage the Link_To_Batch_Control number (ie, the foreign key)
to 6?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jim Mac Millan]

You see this is why I come here . That never even dawned on me. I guess I
could even do that programmatically on a form so I don't even have to look
at those tables.

Thanks Roger
Jim Mac Millan