Access 2013 design question

DGWhittaker
DGWhittaker used Ask the Experts™
on
I have two streams of data that ultimately feed the same activities.

The tables are similar but different.
There are fields in one that identify the original source of the data.

My desired state would be for the system to treat this as a single set of data. Then query it to pull the results needed.

Before I go too deep into this, I thought my expert friends may be able to provide some best practices used in similar scenarios.

Thanks!
Dennis
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
how often are the data streams updated? Is it feasible to store the data in one table? That would be my preference.  Otherwise, you can use a UNION query to combine the fields from multiple recordsets into one long list

Author

Commented:
They are updated monthly.
Thanks!
Dennis
Remote Training and Programming
Top Expert 2015
Commented:
You're welcome.  I'd suggest one table with a field to differentiate where each record came from.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial