<div>
Worked perfectly, thank you.
</div>


<div>
<div class="content wysiwyg-content">
I have a master client table that is linked to 3 other tables through the same key. &nbsp;Is there a way I can generate a report that displays the contents of all 3 tables based on the current record in the master table?<br />
<br />
My data structure is as follows:<br />
<br />
client.ncid&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;pfssc<wbr />hool.ncid<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;&gt;&gt;&gt;&gt;&gt;pfsadd.ncid<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;&gt;&gt;&gt;&gt;&gt;pfsemploy.ncid<br />
<br />
I need my report to display the one-to-many data for all 3 tables. &nbsp;Is this possible?
</div>
</div>


I have a master client table that is linked to 3 other tables through the same key.  Is there a way I can generate a report that displays the contents of all 3 tables based on the current record in the master table?

My data structure is as follows:

client.ncid>>>>>>>>>>pfsschool.ncid
                         >
                         >
                         >>>>>>pfsadd.ncid
                         >
                         >
                         >>>>>>pfsemploy.ncid

I need my report to display the one-to-many data for all 3 tables.  Is this possible?

In Visual Foxpro, is there a way to display multiple one-to-many relationships on the same report

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.