<div>
Thanks. Queries are pretty standard showing a few fields from the parent and the rest from 'many' side. Union queries are limited in the sense that you have to have same fields. Some of my fields are different. Don't know how to manage these. <br />
<br />
Cheers
</div>


Thanks. Queries are pretty standard showing a few fields from the parent and the rest from 'many' side. Union queries are limited in the sense that you have to have same fields. Some of my fields are different. Don't know how to manage these.

Cheers

<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


<div>
<div class="content wysiwyg-content">
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. &nbsp;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. &nbsp;I tried to create a query but the record set is not representative of both project tables. &nbsp;Is there any other approach I may take to resolve this? &nbsp;
</div>
</div>


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?  

Amalgamating Different 'Many' Tables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.