I am trying to do a database cleanup, 3 divisions which were in 1 db have been split, db copied and now I have to remove those models which are no longer applicable to my division. To make a long story short I now have numerous FAD's in my db which are not assigned to any EPC's. Logically I could identify these by:
query-find FAD's,
query-find functions within these models
???now I need the logic to count the occurrences of these functions. Anything = 1 I can delete.
Of course I can go through the list of functions one by one and do properties/occurrences, but I have 2,560 FAD's that I need to go through, automation is good.
I prefer a query, but a report could be helpful.
Any suggestions?
thanks
donald dillon