In this question I'm looking for some conceptual guidance rather than specific help.
I am creating an Access front end to make it easier for users to view or write information from a couple of different databases. Some of them are Access based on a network drive and a couple are on a SQL Server.
I am hoping to start the users out on a SEARCH FORM where they can get to the RESULTS FORM by typing in any number of limiters. I wrote a quick loop through the text boxes to create the sql statement which works fine on a single database. Since I have multiple databases would it be fair to do the same for each database and add the matching records to a recordset and then display that recordset in the unbound RESULTS FORM? The user would choose by clicking on the row of which address they want to look and be sent over to the DETAILS FORM that uses subforms for each database based on the street address.
The nearest thing to a common key among the databases is a street address of the property. Since the addresses may be keyed differently across db's it may be difficult.
Or is there some other way people have found to consolidate several db's onto a single tabbed form with subforms?
I inlcuded a picture of the basic layout so far. Search.jpg
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.