BAQ help - Missing fields?

Jim,

That worked perfectly, thanks!!



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jim Frice
Sent: Monday, January 14, 2008 3:55 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ help - Missing fields??



Try the PlantWhse table with field PrimBin.

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Matt Caldwell
Sent: Monday, January 14, 2008 1:59 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ help - Missing fields??

We are trying to list our parts, whse, and bin numbers. The data that we are looking for is listed on the Partà Plantsà Warehousesà Detailà Primary Bin field. I went into Developer mode to see what field that primary bin is attached to, and I found that it is PartWhse.PrimBinNum. When I go to make a BAQ , that field does not show up. I pulled the tables Part and PartWhse. There is NOT a filed called PrimBinWhse in the PartWhse table. I even looked up PartWhse in the Data Dictionary Viewer, and it isn't listed there either. Can anyone shed some light on this??

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com <http://www.kerusso.com>
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

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

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





[Non-text portions of this message have been removed]
We are trying to list our parts, whse, and bin numbers. The data that we are looking for is listed on the Partà Plantsà Warehousesà Detailà Primary Bin field. I went into Developer mode to see what field that primary bin is attached to, and I found that it is PartWhse.PrimBinNum. When I go to make a BAQ , that field does not show up. I pulled the tables Part and PartWhse. There is NOT a filed called PrimBinWhse in the PartWhse table. I even looked up PartWhse in the Data Dictionary Viewer, and it isn't listed there either. Can anyone shed some light on this??



Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************





[Non-text portions of this message have been removed]
Try the PlantWhse table with field PrimBin.

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Matt Caldwell
Sent: Monday, January 14, 2008 1:59 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ help - Missing fields??



We are trying to list our parts, whse, and bin numbers. The data that we are looking for is listed on the Partà Plantsà Warehousesà Detailà Primary Bin field. I went into Developer mode to see what field that primary bin is attached to, and I found that it is PartWhse.PrimBinNum. When I go to make a BAQ , that field does not show up. I pulled the tables Part and PartWhse. There is NOT a filed called PrimBinWhse in the PartWhse table. I even looked up PartWhse in the Data Dictionary Viewer, and it isn't listed there either. Can anyone shed some light on this??

Matt Caldwell
Technical Support Analyst

KERUSSO
P.O. Box 32
Berryville, AR 72616
Phone: 800-424-0943 Ext. 231
Fax: 870-423-3568
Web Site: http://www.kerusso.com <http://www.kerusso.com>
******************************************************************
CONFIDENTIALITY STATEMENT:
This message, from Kerusso Inc., contains information
which is privileged and confidential and is solely for the use of
the intended recipient. If you are not the intended recipient, be
aware that any review, disclosure, copying, distribution, or use
of the contents of this message is strictly prohibited. If you have
received this in error, please destroy it and notify us immediately
at: 800-424-0943
******************************************************************

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






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