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?