Wits end! head scratching almost bald. I renamed 49ee1862 to JUNK I renamed CustomerNo to CustNo deleted all rows in junk deleted all columns in junk except CustNo which I cannot delete as it is referenced????
list fkeys does not show it I checked all tables that have anything to do with a Customer No. and all keys seem to be correct. There must be an easier way to get the relationship between keys but I can't seem to discover it. I did an unload of structure and examined that file but couldn't find anything. Stll thinking but it's getting close to bed time. Bernie Lis
