(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Orphan Records - How to delete them?
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Orphan Records - How to delete them? (Read 518 times)
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Orphan Records - How to delete them?
Nov 29th, 2011 at 3:51pm
Print Post Print Post  
What is the easiest way and best way to find out orphan subform records and remove them?
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Orphan Records - How to delete them?
Reply #1 - Nov 29th, 2011 at 3:58pm
Print Post Print Post  
Assuming your records are naturally linked:
  • Open the subform in Search/Update mode.
  • Look in the Command Area under Special Search Options for the Find Orphaned Records button. Click it to retrieve all the orphaned subrecords.
  • Once you have them, you can mass delete them.


If your records are relationally linked, let me know as you will need to use a mass update to find the orphans.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Bharat_Naik
Senior Member
Members
*****
Offline


Ever ready to learn and
share

Posts: 1202
Location: Chicago,  Illinois
Joined: Dec 16th, 2003
Re: Orphan Records - How to delete them?
Reply #2 - Nov 29th, 2011 at 4:33pm
Print Post Print Post  
OMG! Is it that easy?  I was thinking about all different possible ways.  They are all naturally linked. Thanks...
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge