Active TopicsActive Topics  Display List of Forum MembersMemberlist  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
Please consider donating $1 per sample downloaded, find out why here. If downloading multiple samples, please donate once for all of them.
Amazon Honor System  Click Here
to Pay Learn More
Access 97, 2000, 2002 (XP) (Forum Locked Forum Locked)
 RAL Forums : Access 97, 2000, 2002 (XP)
Subject Topic: Searching Multiple Tables Post ReplyPost New Topic
Message << Prev Topic | Next Topic >>

Joined: 29 October 2004
Location: United States
Posts: 1
Posted: 29 October 2004 at 2:26pm | IP Logged Quote frankbart

I have a database that has 4 tables. One contains VictimsList another contains WitnesseList and the third contains Suspectlist, they are all linked to a primary table that ties them all together. I am looking for a way to search for names in all three tables at the same time rather than search each seperatlly. Any help would be great.



Back to Top View frankbart's Profile Search for other posts by frankbart Send Private Message Add to Buddy List

Joined: 01 November 2004
Location: United States
Posts: 3
Posted: 01 November 2004 at 1:45pm | IP Logged Quote Rohini

Did you tried performing Union Join on the 4 tables and then performing the Search criterion? I think this should help.

Back to Top View Rohini's Profile Search for other posts by Rohini Send Private Message Add to Buddy List

Sorry, you can NOT post a reply.
This forum has been locked by a forum administrator.

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

Powered by Web Wiz Forums version 7.01
Copyright ©2001-2003 Web Wiz Guide