Hi
Thats because you may have unknowingly used the same reason code ID for
different reason code types
It is linking to each of them and giving you multiple returns.
If they are non-conformance reason codes you need to filter the codes
with 'reasontype' of 's'. Stands for Scrap apparently
Hope this helps
Gary Parfrey
Operations Manager
Steatite Limited
TEL: 0044 (0)1527 406880
FAX: 0044 (0)1527 406899
www.steatite.com
_____
From: progress92000 [mailto:nvong@...]
Sent: 22 November 2004 14:29
To: vantage@yahoogroups.com
Subject: [Vantage] link nonconf to reason table
Can anyone tell me how to link two table, nonconf and reason, I got
repeating.
Thanks
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
<http://us.ard.yahoo.com/SIG=129njdjut/M=281955.5530326.6602771.3001176/
D=groups/S=1705007183:HM/EXP=1101220151/A=2343726/R=0/SIG=12iu0rrl3/*htt
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=11011337512
04252>
<http://us.ard.yahoo.com/SIG=129njdjut/M=281955.5530326.6602771.3001176/
D=groups/S=1705007183:HM/EXP=1101220151/A=2343726/R=1/SIG=12iu0rrl3/*htt
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=11011337512
04252>
Get unlimited calls to
U.S./Canada
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=1101
133751204252>
<http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=group
s/S=:HM/A=2343726/rand=534914911>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Thats because you may have unknowingly used the same reason code ID for
different reason code types
It is linking to each of them and giving you multiple returns.
If they are non-conformance reason codes you need to filter the codes
with 'reasontype' of 's'. Stands for Scrap apparently
Hope this helps
Gary Parfrey
Operations Manager
Steatite Limited
TEL: 0044 (0)1527 406880
FAX: 0044 (0)1527 406899
www.steatite.com
_____
From: progress92000 [mailto:nvong@...]
Sent: 22 November 2004 14:29
To: vantage@yahoogroups.com
Subject: [Vantage] link nonconf to reason table
Can anyone tell me how to link two table, nonconf and reason, I got
repeating.
Thanks
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Sponsor
<http://us.ard.yahoo.com/SIG=129njdjut/M=281955.5530326.6602771.3001176/
D=groups/S=1705007183:HM/EXP=1101220151/A=2343726/R=0/SIG=12iu0rrl3/*htt
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=11011337512
04252>
<http://us.ard.yahoo.com/SIG=129njdjut/M=281955.5530326.6602771.3001176/
D=groups/S=1705007183:HM/EXP=1101220151/A=2343726/R=1/SIG=12iu0rrl3/*htt
p://clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=11011337512
04252>
Get unlimited calls to
U.S./Canada
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=1101
133751204252>
<http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=group
s/S=:HM/A=2343726/rand=534914911>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]