Amalgamating Different 'Many' Tables
Posted on 2007-07-23
I have a stores table that has 'many' relationship with projects table. Recently, I had to introduce an entirely diiferent projects category, so I created a another projects table with 1-M relationship with the stores table. So now I have got two projects table with one parent. The system works for me as data entry can be carried out seperately, however, there is a need for the business to report on projects in both tables using a single report. I tried to create a query but the record set is not representative of both project tables. Is there any other approach I may take to resolve this?