I have two departments each with their own QB database. Both departments track time on related projects. Each department keeps different information about the work done on their timelog tables, but many fields are parallel. We have a third QB database where we pull information together. I want to pull information from the timelog tables on each of the department databases into a single table in the common database. I want to be able to view individual records and summarized data from the common database level. I also need the data to be as up to date as possible.
So far I have set up two timelog sync tables in the common database. One from each department database. Ideally, I would have one table in the common database that is synced to each timelog table in the department databases. Is this possible?
My second option is to find a way to pull the data from the two sync tables in the common database into a third table in the common database. If I go this route I would like to automate the process. Is this possible?
Thanks...Mary
