<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6617.47">
<TITLE>What is this?</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">How do I avoid this error, please?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">*E* This selection is based on a higher file in the access list.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Here is my access list ...</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">access *mipss600b &</FONT>
<BR><FONT SIZE=2 FACE="Arial"> link d_ordno_1 to order_no of &</FONT>
<BR><FONT SIZE=2 FACE="Arial"> order_master in isdb alias order_master_a1 &</FONT>
<BR><FONT SIZE=2 FACE="Arial"> link d_ordno_1 to order_no of &</FONT>
<BR><FONT SIZE=2 FACE="Arial"> order_detail in isdb alias order_detail_a1 opt &</FONT>
<BR><FONT SIZE=2 FACE="Arial"> link (primary_id of order_detail_a1, &</FONT>
<BR><FONT SIZE=2 FACE="Arial"> secondary_id of order_detail_a1) to &</FONT>
<BR><FONT SIZE=2 FACE="Arial"> primary_id, secondary_id of &</FONT>
<BR><FONT SIZE=2 FACE="Arial"> secondary_table in isdb alias secondary_table_a1</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">The Secondary Table has a one-to-one relationship with order_detail. I thought that if I made order_detail optional, that the secondary table would also be reliant on the order detail and therefore be optional with it. Is this not correct? I tried it with an OPT in the secondary table and I still get the same error above</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Thanks</FONT>
</P>
<BR>
<BR>
<P><I><FONT COLOR="#0000FF" SIZE=4 FACE="Arial">Fernando Olmos</FONT></I>
<BR><B><FONT SIZE=2 FACE="Arial">MIS</FONT></B>
<BR><B><FONT SIZE=2 FACE="Arial">Senior Analyst Programmer</FONT></B>
</P>
<P><SPAN LANG="en-au"><B><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">HPA</FONT></B></SPAN><B><SPAN LANG="en-us"></SPAN></B><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Arial"><BR>
</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000000" SIZE=2 FACE="Arial">Direct: 03 9217 5411</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><BR>
</SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000000" SIZE=2 FACE="Arial">Mobile: 0410 382 857</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT FACE="Arial"><BR>
</FONT></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><FONT COLOR="#000000" SIZE=2 FACE="Arial">Fax: 03 9217 5716</FONT><FONT FACE="Arial"></FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"> </SPAN>
</P>
<P><SPAN LANG="en-au"></SPAN><A HREF="file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au"><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"><U></U></SPAN><SPAN LANG="en-au"><U><B><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">www.hpa.com.au</FONT></B></U></SPAN><SPAN LANG="en-au"></SPAN></A><SPAN LANG="en-au"></SPAN><SPAN LANG="en-au"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN>
</P>
<BR>
<pre>**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,
then delete the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************
</pre></BODY>
</HTML>