Rb Join for Memo fields

Yahoo Archive
1
Yes I could, I would like to see that as the key1 field is character and
the quotenum is numeric.

If you could send me a copy I would appreciate it.



Keith Mailloux

Nospam##keith.mailloux@...##Nospam



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michelle de la Vega
Sent: Thursday, May 05, 2005 9:26 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Rb Join for Memo fields



I have written a report from the quotes in crystal and had no problem
linking the Memo table to the quotehed table. The only fields I linked
were company and key1 to Quotenum.

Can you use crystal for this report?

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Keith Mailloux
Sent: Thursday, May 05, 2005 9:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Rb Join for Memo fields


I know this has been asked but my research in the archives does not
provide an answer that I have gotten to work. I need to join (left
outer) the Quote Header table to the Memo table. The fields I need to
use to take advantage of the indexes in the Memo table are Quote
Company, RelatedToFile, Key1 . The Quotehdr table does have the Company
field but RelatedToFile is not available and the Key1 field is the
string equivalent of the Quotenum field. Problem with that is the Key1
field in the Memo table is a character field and Quotenum is a numeric
value. I have experimented with vb fields and re-typed the RelatedToFile
value and a string value for the quote number and can make the join work
like that. Question is how can I do it just using the raw data and some
Rb trickery?



Thanks



Keith







[Non-text portions of this message have been removed]



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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links



_____

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]



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
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links




________________________________

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]
2
I know this has been asked but my research in the archives does not
provide an answer that I have gotten to work. I need to join (left
outer) the Quote Header table to the Memo table. The fields I need to
use to take advantage of the indexes in the Memo table are Quote
Company, RelatedToFile, Key1 . The Quotehdr table does have the Company
field but RelatedToFile is not available and the Key1 field is the
string equivalent of the Quotenum field. Problem with that is the Key1
field in the Memo table is a character field and Quotenum is a numeric
value. I have experimented with vb fields and re-typed the RelatedToFile
value and a string value for the quote number and can make the join work
like that. Question is how can I do it just using the raw data and some
Rb trickery?



Thanks



Keith







[Non-text portions of this message have been removed]
3
I have written a report from the quotes in crystal and had no problem linking the Memo table to the quotehed table. The only fields I linked were company and key1 to Quotenum.

Can you use crystal for this report?

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Keith Mailloux
Sent: Thursday, May 05, 2005 9:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Rb Join for Memo fields


I know this has been asked but my research in the archives does not
provide an answer that I have gotten to work. I need to join (left
outer) the Quote Header table to the Memo table. The fields I need to
use to take advantage of the indexes in the Memo table are Quote
Company, RelatedToFile, Key1 . The Quotehdr table does have the Company
field but RelatedToFile is not available and the Key1 field is the
string equivalent of the Quotenum field. Problem with that is the Key1
field in the Memo table is a character field and Quotenum is a numeric
value. I have experimented with vb fields and re-typed the RelatedToFile
value and a string value for the quote number and can make the join work
like that. Question is how can I do it just using the raw data and some
Rb trickery?



Thanks



Keith







[Non-text portions of this message have been removed]



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 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]
4
I have written a report from the quotes in crystal and had no problem linking the Memo table to the quotehed table. The only fields I linked were company and key1 to Quotenum.

Can you use crystal for this report?

Michelle de la Vega
Business Applications Manager
Cold Jet, LLC
513-831-3211 ext 400
513-831-1209 fax
www.ColdJet.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Keith Mailloux
Sent: Thursday, May 05, 2005 9:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Rb Join for Memo fields


I know this has been asked but my research in the archives does not
provide an answer that I have gotten to work. I need to join (left
outer) the Quote Header table to the Memo table. The fields I need to
use to take advantage of the indexes in the Memo table are Quote
Company, RelatedToFile, Key1 . The Quotehdr table does have the Company
field but RelatedToFile is not available and the Key1 field is the
string equivalent of the Quotenum field. Problem with that is the Key1
field in the Memo table is a character field and Quotenum is a numeric
value. I have experimented with vb fields and re-typed the RelatedToFile
value and a string value for the quote number and can make the join work
like that. Question is how can I do it just using the raw data and some
Rb trickery?



Thanks



Keith







[Non-text portions of this message have been removed]



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 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]
5
Things I would try....
Step 1: Dump the raw memo table to an RB report and sort on "RelatedToFile". Look to see if it was spelled differently than the table name. Some are. Maybe filter on RelatedToFile Begins "Q" to make the list smaller if the Memo table is large.

Step 2: Sometimes when fields are not compatible you must join only on what you can (sometimes only Company) and filter on the rest. Inefficient but it can be made to work.

-Todd C.


-----Original Message-----
From: Keith Mailloux [mailto:keith.mailloux@...]
Sent: Thursday, May 05, 2005 8:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Rb Join for Memo fields


I know this has been asked but my research in the archives does not
provide an answer that I have gotten to work. I need to join (left
outer) the Quote Header table to the Memo table. The fields I need to
use to take advantage of the indexes in the Memo table are Quote
Company, RelatedToFile, Key1 . The Quotehdr table does have the Company
field but RelatedToFile is not available and the Key1 field is the
string equivalent of the Quotenum field. Problem with that is the Key1
field in the Memo table is a character field and Quotenum is a numeric
value. I have experimented with vb fields and re-typed the RelatedToFile
value and a string value for the quote number and can make the join work
like that. Question is how can I do it just using the raw data and some
Rb trickery?



Thanks



Keith







[Non-text portions of this message have been removed]



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 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]