multiple data sources, one database

[cutestuff]

hi,

Okay, all I'm looking for is an idea...something to point me in the right direction.
I handle different areas - for instance say, we have NE, SE, NW, SW.
Each of these areas have their own table.
I have a database built for one area only - NE.
But all the other 3 areas need this database too (I wasn't informed of this when I built it).
I would like to know if there is a way to change the source table (I have a table named tblMaster - but only for NE. All the other areas have a similar table in Excel) by maybe a command or something so that if a user wants NE, then the main table is set to the NE table, but if the user picks SW, it is set to SW.

Is that possible?

What I could do is basically duplicate the database for each of these areas. But it seems highly inefficient. I'm sure there's a more efficient way out there somewhere.

Any ideas? Please and thank you .

 

[Golom]

Are you in Calgary by any chance?

NE, SE, NW and SW are just data. I don't know how many tables are affected here but I would look at adding a field to tblMaster and setting it to "NE" for all the current records. Then append records for the other areas, setting the new field to the appropriate value.

Finally, write a query

Select * From tblMaster Where Quadrant = [Enter NE, SE, SW, NW]

And use that as your source. You would of course be more elaborate about how you supplied the parameter than just this InputBox example.

 

[cutestuff]

Thanks!

That's certainly something I can try.
It's just that the tables are quite massive so I was thinking maybe I could separate them.

And yes, I do live in Calgary.

Thanks again!