Copying Related Data In Datasheet View

  • Thread starter Thread starter Jim Mac Millan
  • Start date Start date
J

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
 
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.
 
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
 
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
 
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
 
Back
Top