tyRE: help with an idea


You will need to separate this into multiple BAQ's, and link them in the

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]