Mark,
You will need to separate this into multiple BAQ's, and link them in the
Dashboard.
One Screen will have Part # & Qty
Second Screen will have the Material for this Part & Qty
Third will show PO's for Material
Firth will show Jobs for the Material
Hope this helps,
Rick Hagy
Project Manager
Tel: (804) 523-8115
Fax: (804) 523-8150
http://www.openplan.com <http://www.openplan.com/>
HMU, LLC d/b/a Open Plan Systems
4700 Deepwater Terminal Rd | Richmond, VA 23234
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Trzaska, Mark
Sent: Thursday, February 24, 2011 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] help with an idea
Hi all,
I am looking to create a dashboard that contains the following.
1) Part #
2) Qty on Hand
3) Raw Material part # used to make above Part #
4) Qty on hand for raw material
5) Any raw material on order
6) Active jobs running part #
I know there are many ways to right click to get all this. But I need an
executive style dashboard.
Simple and to the point.
Im having issues figuring out in the BAQ which tables to select and
their corresponding relationships.
If anyone can give me a hint on what would be the tables to use in order
as wee as links that would be helpful.
Thank You
[Non-text portions of this message have been removed]
Effective February 1st a 3% price increase applied to pedestals and lateral files
Effective April 1st a 3% price increase will be applied to all other items.
To view our latest newsletter navigate to: hhttp://www.openplan.com/doc/newsletter/newsletter_OPS_q4_2010.html
To see our new OPS Elevation Seating Line navigate to: http://www.openplan.com/seatingOPS.html
Contact your CSR for discounting information.
Reduce - Reuse - Recycle Buy Open Plan Systems
The content of this message is strictly confidential and is intended for the exclusive use of the addressee. Any unauthorized distribution and copying of this communication is strictly forbidden. If you have received said communication by error, please delete it immediately. HMU, LLC believes that this E-mail and its attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. However, by reading this message and opening any attachments, the addressee accepts full responsibility for taking protective and remedial action about viruses and other defects.
[Non-text portions of this message have been removed]
You will need to separate this into multiple BAQ's, and link them in the
Dashboard.
One Screen will have Part # & Qty
Second Screen will have the Material for this Part & Qty
Third will show PO's for Material
Firth will show Jobs for the Material
Hope this helps,
Rick Hagy
Project Manager
Tel: (804) 523-8115
Fax: (804) 523-8150
http://www.openplan.com <http://www.openplan.com/>
HMU, LLC d/b/a Open Plan Systems
4700 Deepwater Terminal Rd | Richmond, VA 23234
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Trzaska, Mark
Sent: Thursday, February 24, 2011 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] help with an idea
Hi all,
I am looking to create a dashboard that contains the following.
1) Part #
2) Qty on Hand
3) Raw Material part # used to make above Part #
4) Qty on hand for raw material
5) Any raw material on order
6) Active jobs running part #
I know there are many ways to right click to get all this. But I need an
executive style dashboard.
Simple and to the point.
Im having issues figuring out in the BAQ which tables to select and
their corresponding relationships.
If anyone can give me a hint on what would be the tables to use in order
as wee as links that would be helpful.
Thank You
[Non-text portions of this message have been removed]
Effective February 1st a 3% price increase applied to pedestals and lateral files
Effective April 1st a 3% price increase will be applied to all other items.
To view our latest newsletter navigate to: hhttp://www.openplan.com/doc/newsletter/newsletter_OPS_q4_2010.html
To see our new OPS Elevation Seating Line navigate to: http://www.openplan.com/seatingOPS.html
Contact your CSR for discounting information.
Reduce - Reuse - Recycle Buy Open Plan Systems
The content of this message is strictly confidential and is intended for the exclusive use of the addressee. Any unauthorized distribution and copying of this communication is strictly forbidden. If you have received said communication by error, please delete it immediately. HMU, LLC believes that this E-mail and its attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. However, by reading this message and opening any attachments, the addressee accepts full responsibility for taking protective and remedial action about viruses and other defects.
[Non-text portions of this message have been removed]