John Colby
jwcolby at ColbyConsulting.com
Wed Nov 30 13:41:26 CST 2005
Yes, it does cross reference (I have it) but while it does say: A uses B B uses d, f, g, h D uses c,e,x,y It does not say: Therefore A uses B,D,F,G,H,V,E,X,Y Further the Cross reference does not place the data in tables (that I can find) so I can't even build my own thing using the results of the cross reference. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Wednesday, November 30, 2005 2:22 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Tracing the source data Try Rick Fisher's Find and Replace (registered version does x-references) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Wednesday, November 30, 2005 1:22 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Tracing the source data I have a database I am trying to trace the data for. Every form has a table / query. If a query, what queries/tables are used in that? If any queries used in that query, what queries are used in that. IOW, for FormA exactly what queries and tables are required for that form, all the way back down through all the subqueries etc. Same for reports. Is there anything out there that does this for a reasonable price? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com