(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Finding Orphaned Subrecords
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Finding Orphaned Subrecords (Read 652 times)
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Finding Orphaned Subrecords
May 16th, 2005 at 11:39pm
Print Post Print Post  
Is it possible to find (and then delete) orphaned sub-records?


Thanks,

Steve
  
Back to top
WWW WWW  
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Finding Orphaned Subrecords
Reply #1 - May 17th, 2005 at 2:45am
Print Post Print Post  
Steve,

The way I have done this is to:
1) Make copy of the application.
2) Open that copy (be sure it's the copy).
3) Mass Delete all of the parent records.
4) Open the subform as a main form.
5) If there are any orphans, you should see them here. If there are NOT any orphans, you will see the "No records returned by query" message at the bottom of the Sesame window.
  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: Finding Orphaned Subrecords
Reply #2 - May 17th, 2005 at 2:18pm
Print Post Print Post  
Great tip, Carl.

I'll give it a try.

Thanks!

Steve
  
Back to top
WWW WWW  
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