BAM Question

system · March 22, 2006, 11:17am

BAQ

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Podlin, Michael
Sent: Wednesday, March 22, 2006 8:09 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Question

BAM - Business Activity Manager vs. BAQ - Business Activity Query.

Your subject calls out BAM, yet your message is for a BAQ. These are
total different items. The BAM is used to launch a .p program which you
can easily write a .p procedure to link the memo text field to a
numberic value of another table. The BAQ is a Progress Query, and you
should also be able to create the query linking the memo text field to a
numberic value of another table.

BAM or BAQ, which are you looking for?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Chris Crosta
Sent: Wednesday, March 22, 2006 9:57 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Question

Having never defined variables in a BAQ where can I go to get more
information and or examples? The fields will defiantly need to be
converted as one is a string and the other a number.

Thanks,

Chris

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Wednesday, March 22, 2006 5:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Question

Chris,
You may have to define a variable that matches the format of the Memo
table
field, set the value = to the conversion of the original Orderhed field
data
and then link based on Memo.Key1 = variable.
If I remember correctly the Memo fields don't match the format of the
original table data, so you have to convert to link them in the BAM.
I am not 100% sure on the above information, but I think this will point
you
in the right direction.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Chris Crosta
Sent: Tuesday, March 21, 2006 7:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Question

How can I link the "Memo" table to the "Orderhed" table in a BAQ? I can
link these tables in Crystal through (OrderHed.OrderNum-Memo.Key1).

Thanks,

Chris

[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

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

SPONSORED LINKS

Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>

Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>

Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>

Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>

Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>

Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

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

system · March 21, 2006, 7:01pm

How can I link the "Memo" table to the "Orderhed" table in a BAQ? I can
link these tables in Crystal through (OrderHed.OrderNum-Memo.Key1).

Thanks,

Chris

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

system · March 22, 2006, 8:40am

Chris,
You may have to define a variable that matches the format of the Memo table
field, set the value = to the conversion of the original Orderhed field data
and then link based on Memo.Key1 = variable.
If I remember correctly the Memo fields don't match the format of the
original table data, so you have to convert to link them in the BAM.
I am not 100% sure on the above information, but I think this will point you
in the right direction.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Chris Crosta
Sent: Tuesday, March 21, 2006 7:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Question

How can I link the "Memo" table to the "Orderhed" table in a BAQ? I can
link these tables in Crystal through (OrderHed.OrderNum-Memo.Key1).

Thanks,

Chris

[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

system · March 22, 2006, 10:57am

Having never defined variables in a BAQ where can I go to get more
information and or examples? The fields will defiantly need to be
converted as one is a string and the other a number.

Thanks,

Chris

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Wednesday, March 22, 2006 5:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Question

Chris,
You may have to define a variable that matches the format of the Memo
table
field, set the value = to the conversion of the original Orderhed field
data
and then link based on Memo.Key1 = variable.
If I remember correctly the Memo fields don't match the format of the
original table data, so you have to convert to link them in the BAM.
I am not 100% sure on the above information, but I think this will point
you
in the right direction.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Chris Crosta
Sent: Tuesday, March 21, 2006 7:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Question

How can I link the "Memo" table to the "Orderhed" table in a BAQ? I can
link these tables in Crystal through (OrderHed.OrderNum-Memo.Key1).

Thanks,

Chris

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

system · March 22, 2006, 11:09am

BAM - Business Activity Manager vs. BAQ - Business Activity Query.

Your subject calls out BAM, yet your message is for a BAQ. These are total different items. The BAM is used to launch a .p program which you can easily write a .p procedure to link the memo text field to a numberic value of another table. The BAQ is a Progress Query, and you should also be able to create the query linking the memo text field to a numberic value of another table.

BAM or BAQ, which are you looking for?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Chris Crosta
Sent: Wednesday, March 22, 2006 9:57 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Question

Having never defined variables in a BAQ where can I go to get more
information and or examples? The fields will defiantly need to be
converted as one is a string and the other a number.

Thanks,

Chris

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Wednesday, March 22, 2006 5:40 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAM Question

Chris,
You may have to define a variable that matches the format of the Memo
table
field, set the value = to the conversion of the original Orderhed field
data
and then link based on Memo.Key1 = variable.
If I remember correctly the Memo fields don't match the format of the
original table data, so you have to convert to link them in the BAM.
I am not 100% sure on the above information, but I think this will point
you
in the right direction.
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Chris Crosta
Sent: Tuesday, March 21, 2006 7:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAM Question

How can I link the "Memo" table to the "Orderhed" table in a BAQ? I can
link these tables in Crystal through (OrderHed.OrderNum-Memo.Key1).

Thanks,

Chris

[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