BAQ - xfileattch and xfileref tables

Michelle,

The fields Key1, Key2, Key3 in table XFileAttch hold the values I think you would be interested in for filtering.


Key1 holds the ponum, job number, partnum etc.

Key2 holds the assembly seq, po line.

Key3 the job material seq number.


Hope that helps.

-Ted



________________________________
From: Michelle Chamberlain <mchamberlain@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, February 2, 2012 2:00 PM
Subject: [Vantage] BAQ - xfileattch and xfileref tables

In a BAQ, I have pulled in xfileattch and xfileref tables tied to the Partlot table. What is the trick to only show the attachment file name that is tied to a specific lot?

Thanks

Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line:Â (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817

________________________________
Sabre Industries, Inc. ("Sabre") E-MAIL NOTICE - This transmission and any attachments may be confidential or subject to a legally recognized privilege and is intended only to be received and read by the proper party having a reason to send communications to or from Sabre. If you do not believe that you are the proper recipient of this message because of its address, contents and/or otherwise believe that this message was sent to you in error, you should not disclose, print, copy or disseminate the information contained in this message. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law and state laws.
The text in this communication does not reflect an intention by Sabre to conduct a transaction or make any agreement by electronic means. Only a document which bears a handwritten signature of an authorized signatory of Sabre shall be binding upon Sabre and such documents may be attached indicating a desire to conduct a transaction or make any agreement. Nothing contained in the text of this message shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions or any statutory adoptions or equivalents of the aforementioned acts and convention, and any other laws or regulations of any state or country related to electronic contracts, electronic signatures, or electronic records shall not apply to Sabre or the
recipient.
________________________________



[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/.%c2%a0
(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/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
In a BAQ, I have pulled in xfileattch and xfileref tables tied to the Partlot table. What is the trick to only show the attachment file name that is tied to a specific lot?

Thanks

Michelle Chamberlain
ERP Analyst
Sabre Industries
Direct Line: (712) 224-1452
Phone: (712) 258-6690 ext. 11452
Fax: (712) 279-0817

________________________________
Sabre Industries, Inc. ("Sabre") E-MAIL NOTICE - This transmission and any attachments may be confidential or subject to a legally recognized privilege and is intended only to be received and read by the proper party having a reason to send communications to or from Sabre. If you do not believe that you are the proper recipient of this message because of its address, contents and/or otherwise believe that this message was sent to you in error, you should not disclose, print, copy or disseminate the information contained in this message. If you have received this in error, please reply and notify the sender (only) and delete the message. Unauthorized interception of this e-mail is a violation of federal criminal law and state laws.
The text in this communication does not reflect an intention by Sabre to conduct a transaction or make any agreement by electronic means. Only a document which bears a handwritten signature of an authorized signatory of Sabre shall be binding upon Sabre and such documents may be attached indicating a desire to conduct a transaction or make any agreement. Nothing contained in the text of this message shall satisfy the requirements for a writing, and nothing contained herein shall constitute a contract or electronic signature under the Electronic Signatures in Global and National Commerce Act, any version of the Uniform Electronic Transactions Act or any other statute governing electronic transactions or any statutory adoptions or equivalents of the aforementioned acts and convention, and any other laws or regulations of any state or country related to electronic contracts, electronic signatures, or electronic records shall not apply to Sabre or the recipient.
________________________________



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