<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6603.0">
<TITLE>Primary vs Secondary files</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">This sounds crazy, but I thought secondary files were meant to automatically add/update/delete along with the primary file in quick.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">I have a simple code...</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">screen tmp</FONT>
<BR><FONT SIZE=2 FACE="Arial">file copy_file in isdb primary</FONT>
<BR><FONT SIZE=2 FACE="Arial">select if copy_type = 'xx'</FONT>
<BR><FONT SIZE=2 FACE="Arial">file www_users in natdb</FONT>
<BR><FONT SIZE=2 FACE="Arial">item user_id final user_id of copy_file</FONT>
<BR><FONT SIZE=2 FACE="Arial">item domain final "VIC"</FONT>
<BR><FONT SIZE=2 FACE="Arial">gen</FONT>
<BR><FONT SIZE=2 FACE="Arial">go</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">The primary key of the www_users table is the user_id and domain field combo. The primary key of the copy_file is user_id and a column called copy_type which in this case must be 'xx'</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Well the screen builds and runs perfectly, but when I add a new record to copy_file, there is nothing been added to www_users.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">I haven't worked with qdesign for a long time and my faint memory cells, tell me this was once a possibility. I guess I am missing something here.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Thanks</FONT>
</P>
<P><I><FONT COLOR="#0000FF" SIZE=4 FACE="Arial">Fernando Olmos</FONT></I>
<BR><B><FONT SIZE=2 FACE="Arial">M.I.S.</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>
</BODY>
</HTML>