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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |