Can't really join them directly. You link by "company" only and then filter
for the related-to file and key1,2,3 that you are looking for. Maybe also
for a specific memo category. This ends up creating a HUGE record complex
and can run sort of slow but if you sequence your filters right it can
improve speed a lot. Also, the filter for keys might require some
string/numeric conversions to get them to be able to be compared in the
filter. Hope this helps get you started.
-Todd C.
-----Original Message-----
From: judyh001 [mailto:judy.havlik@...]
Sent: Friday, April 19, 2002 12:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Memos - Vantage 4.0
Speaking of Memos, we have never tried to print the memo field or use
them in any way with Report Builder (Version 9.0B). Now, we might
like to see some of the information contained in the ORDERHED memo.
I'm sure it's been discussed many times but I couldn't find it in the
search archive...how do you join the OrderHed to Memo to be able to
access such data as the Order date, the Memo date and text?
Sincerely,
Judy Havlik
Plitek, L.L.C.
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=217097.2003762.3481930.1261774/D=egroupweb/S=17050071
83:HM/A=1042587/R=0/*http://service.bfast.com/bfast/click?bfmid=29150849&sit
eid=39282504&bfpage=account>
<http://us.adserver.yahoo.com/l?M=217097.2003762.3481930.1261774/D=egroupmai
l/S=1705007183:HM/A=1042587/rand=833898834>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
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]
for the related-to file and key1,2,3 that you are looking for. Maybe also
for a specific memo category. This ends up creating a HUGE record complex
and can run sort of slow but if you sequence your filters right it can
improve speed a lot. Also, the filter for keys might require some
string/numeric conversions to get them to be able to be compared in the
filter. Hope this helps get you started.
-Todd C.
-----Original Message-----
From: judyh001 [mailto:judy.havlik@...]
Sent: Friday, April 19, 2002 12:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Memos - Vantage 4.0
Speaking of Memos, we have never tried to print the memo field or use
them in any way with Report Builder (Version 9.0B). Now, we might
like to see some of the information contained in the ORDERHED memo.
I'm sure it's been discussed many times but I couldn't find it in the
search archive...how do you join the OrderHed to Memo to be able to
access such data as the Order date, the Memo date and text?
Sincerely,
Judy Havlik
Plitek, L.L.C.
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=217097.2003762.3481930.1261774/D=egroupweb/S=17050071
83:HM/A=1042587/R=0/*http://service.bfast.com/bfast/click?bfmid=29150849&sit
eid=39282504&bfpage=account>
<http://us.adserver.yahoo.com/l?M=217097.2003762.3481930.1261774/D=egroupmai
l/S=1705007183:HM/A=1042587/rand=833898834>
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
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]