<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV><SPAN class=688280523-15082006><FONT face=Arial color=#0000ff size=2>Yep.
That is plan B. ;)</FONT></SPAN></DIV>
<DIV><SPAN class=688280523-15082006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=688280523-15082006><FONT face=Arial color=#0000ff size=2>Thanks
anyway. I've already done it with a prepass to create a subfile and then using
that subfile linked to the primary table. A display saying that duplicate
entries will be ignored should teach the users.</FONT></SPAN></DIV>
<DIV><SPAN class=688280523-15082006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=688280523-15082006><FONT face=Arial color=#0000ff size=2>Thank
you</FONT></SPAN></DIV>
<DIV><SPAN class=688280523-15082006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> mcl_systems@telus.net
[mailto:mcl_systems@telus.net] <BR><B>Sent:</B> Wednesday, 16 August 2006 9:00
AM<BR><B>To:</B> Fernando Olmos<BR><B>Subject:</B> Re: Unique CHOOSE
values<BR><BR></FONT></DIV>I don't think it can be done using the CHOOSE
statement alone. You'd have to put in a front end of some sort to do that for
you. A quick screen or a prepass that would take the values and write them
uniquely to a subfile or some such thing.<BR><BR>
<BLOCKQUOTE cite=midC5B2133CD2641C4EA593D2143A5FA0A8513E12@exchange2k
type="cite"><PRE wrap=""> </PRE></BLOCKQUOTE><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>