A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Find a record across tables



 
 
Thread Tools Display Modes
  #1  
Old February 14th, 2006, 12:41 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Find a record across tables

I have a scenario where there are around 50 tables in a MDB file. i need to
find a particular record which is stored in any of the 50 tables.

Please suggest a solution

thankyou

AMIT
  #2  
Old February 14th, 2006, 12:56 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Find a record across tables

No offense, but it sounds as though your database isn't very well designed:
not knowing which of 50 tables something could be in doesn't sound right!

Are the 50 tables identical, except for one thing? For instance, do you have
one table for each department in a company, or one for each product that's
sold, or something like that? Odds are you should have a single table with
one additional field to distinguish that additional dimension.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"AMIT SANGLIKAR" AMIT wrote in message
...
I have a scenario where there are around 50 tables in a MDB file. i need

to
find a particular record which is stored in any of the 50 tables.

Please suggest a solution

thankyou

AMIT



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding Records from Sub-Form Table Chas Large General Discussion 12 January 10th, 2006 12:11 PM
Need Help In Printing Current Record in Specific Report RNUSZ@OKDPS Setting Up & Running Reports 1 May 16th, 2005 09:06 PM
Find Record in Subform Shalyn General Discussion 3 May 12th, 2005 06:45 AM
Design help, please SillySally Using Forms 27 March 6th, 2005 05:11 AM
find last modified record zealousagenda Running & Setting Up Queries 1 September 24th, 2004 09:41 AM


All times are GMT +1. The time now is 08:45 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.