Part of the database. I'm not sure where you do it in Access, if you're sticking with that.
cheers, barneyb On Wed, 10 Nov 2004 23:09:40 -0500, Roberto Perez <[EMAIL PROTECTED]> wrote: > At 01:25 PM 11/11/04, Deanna Schneider wrote: > > > And, if you > >index on the foreign key, the database will be able to retrieve the related > >records without doing a full table scan. > > > Thanks for the answer. So, the indexing of the foreign key (also mentioned > by Keith) is something I would do internally at the database level, or is > it CF related, like a Verity collection that indexes content? > > Thanks, > > > Roberto Perez > [EMAIL PROTECTED] > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ I currently have 0 GMail invites for the taking ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184089 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54