AnsweredAssumed Answered

Listing orphaned data

Question asked by miw on Jan 22, 2009
Latest reply on Jan 22, 2009 by miw


Listing orphaned data


Is there a script to run which would identify bad "orphaned" data between relationship tables?  In other words, let's say I had a "product code" field link between two tables in which that code was set in a field for each table and linked.  If a product code in Table 1 was subsequently erased or changed, it might not then be reflected in the Table 2.  Is there a script I can run to find such orphaned data in Table 2 and show a listing thereof?