Memo fields

Yahoo Archive
1
Just wanted to share my solution with everyone.

I added the Memo table as a sub report. Then on the main report I created a
formula field converting the OrderHed.Ordernum field to a string, at the
same time removing the two decimal places and the any commas. Next using the
new formula field I link to the Memo.Key1 field on the sub report. And
finally I filter the Memo.RelatedToFile to equal OrderHead.

Thanks,

Ron Newell
IT Manager
Pattison Sign Group
165 Waterloo Ave.
Penticton, BCÂ V2A 7J3
Phone: 250-492-4522 EX:101
Fax: 250-492-3462
Â

Â
http://www.pattisonsign.com
mailto:rnewell@...



-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, June 06, 2003 9:41 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Memo fields

I don't recall if this was one of the cases but often when dealing with
memos I've had to link by only company then filter down to what I really
want. Can run really slooooow.
-Todd C.

-----Original Message-----
From: Ron Newell [mailto:rnewell@...]
Sent: Friday, June 06, 2003 11:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Memo fields


Hi,

Has anyone found a way to link a memo field to an ordered table? Since they
link by different types of fields (One a string the other a number). I have
set the RelatedToFile field to OrderHed but the OrderNum and Key1 fields
will not link. This is all in ODBC.

Any suggestions would be appreciated.



Ron Newell
IT Manager
Pattison Sign Group
165 Waterloo Ave.
Penticton, BC V2A 7J3
Phone: 250-492-4522 EX:101
Fax: 250-492-3462



http://www.pattisonsign.com
mailto:rnewell@...





Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=17050071
83:HM/A=1564416/R=0/SIG=11ti81skc/*http://www.netflix.com/Default?mqso=60164
797&partid=3170658>

<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmai
l/S=:HM/A=1564416/rand=902519245>

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

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/.
(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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Having a problem with one table (so far) using ODBC and Access. The
table is the Customer table, and this error comes up when trying to
link the table.

Microsoft Access

The operation failed. There are too many indexes on table
Pub_Customer. Delete some indexes on the table and try the operation
again.

Had no trouble in 5.1.

I have run the ODBC fix routine.

I also have updated Office recently.

Any help would be greatly appreciated.

Mike Gilchrist
3
If you search back through the archives on this list you'll find a lot of
discussion about this. Basically, there was a change in vantage 5.2 and you
can no longer access the customer table through ODBC from access. There are
workarounds which you should be able to find in the archives...



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

Has anyone found a way to link a memo field to an ordered table? Since they
link by different types of fields (One a string the other a number). I have
set the RelatedToFile field to OrderHed but the OrderNum and Key1 fields
will not link. This is all in ODBC.

Any suggestions would be appreciated.



Ron Newell
IT Manager
Pattison Sign Group
165 Waterloo Ave.
Penticton, BCÂ V2A 7J3
Phone: 250-492-4522 EX:101
Fax: 250-492-3462
Â

Â
http://www.pattisonsign.com
mailto:rnewell@...
5
I don't recall if this was one of the cases but often when dealing with memos I've had to link by only company then filter down to what I really want. Can run really slooooow.
-Todd C.

-----Original Message-----
From: Ron Newell [mailto:rnewell@...]
Sent: Friday, June 06, 2003 11:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Memo fields


Hi,

Has anyone found a way to link a memo field to an ordered table? Since they
link by different types of fields (One a string the other a number). I have
set the RelatedToFile field to OrderHed but the OrderNum and Key1 fields
will not link. This is all in ODBC.

Any suggestions would be appreciated.



Ron Newell
IT Manager
Pattison Sign Group
165 Waterloo Ave.
Penticton, BC V2A 7J3
Phone: 250-492-4522 EX:101
Fax: 250-492-3462



http://www.pattisonsign.com
mailto:rnewell@...





Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=1705007183:HM/A=1564416/R=0/SIG=11ti81skc/*http://www.netflix.com/Default?mqso=60164797&partid=3170658>
<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmail/S=:HM/A=1564416/rand=902519245>

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

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]