asked on
Access 2013 design question
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
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
Microsoft Access
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
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
ASKER
They are updated monthly.
Thanks!
Dennis
Thanks!
Dennis
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.