Ok, I have a history database and a live database. I want to combine the two for a report. So should I make a view of the live company or the history company?
Right now I have a view created from the live company and when I run the report, it is not giving me the order dates from the live company, just the history company. Do I have the view setup wrong or are my links setup wrong in database expert?
New to making views, so need some help.