Joining Tables

Yahoo Archive
1
This is what my Manufacturing Manager wants:

1.Open Jobs for Even Month

Fields:
JobNum
ReqDate
ReqQty
Partnum
Customer Name

Calculated Fields:
1. UnitPriceXQuantity=
2. QuantityXUnitcost=

HELP? HELP? This is my 1st Report.
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Tuesday, November 07, 2000 2:06 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Joining Tables


Marites,

You should not join the req date to anything. That field should not be
one
of your joins at all. If you explain what information you are trying to
get
at, I can try to explain the proper joins to you.

Sarah Vareschi
Information Systems Engineer
NyproMold, Inc.
33 School Street
Clinton, MA 01510
sarah.vareschi@...

------------------------------------

Hello all,

I need some help with a Report Builder, I have a report that contains
Jobnum, required date, required quantity and partnum. The problem is that
I
only found Reqdate under JobMtl and nothing else. Can anyone tell me where
else to find ReqDate besides JobMtl so I can join the tables?!? Or Am I
missing something?!?!
Jobnum=Jobhead, JobAsmbl
ReqDate= ? ?
ReqQuantity= JobAsmbl, JobMtl

Any help would be greatly appreciated.
Thanks
Marites Marlar
MIS Department
SPS Non-Ferrous
(702) 262-9922 ext. 118



eGroups Sponsor


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)



[Non-text portions of this message have been removed]
2
Hello all,

I need some help with a Report Builder, I have a report that contains
Jobnum, required date, required quantity and partnum. The problem is that I
only found Reqdate under JobMtl and nothing else. Can anyone tell me where
else to find ReqDate besides JobMtl so I can join the tables?!? Or Am I
missing something?!?!

Jobnum=Jobhead, JobAsmbl
ReqDate= ? ?
ReqQuantity= JobAsmbl, JobMtl

Any help would be greatly appreciated.

Thanks

Marites Marlar
MIS Department
SPS Non-Ferrous
(702) 262-9922 ext. 118
3
Marites,

If you are trying to link to the required MFG qty. I would say you are
going to need to connect to the Order Tables. Depending on the Order, you
will need to get the Order Detail and possibly the Order Releases.


_________________
John Koppes
Systems Coordinator
PRECISION MACHINE AND MANUFACTURING COMPANY
Address: PO Box 157
Story City, Iowa 50248
Phone: (515) 733-5181 Ext. 256
Fax: (515) 733-4220
Email: jkoppes@...



"Marites
Marlar" To: <vantage@egroups.com>
<mmarlar@spst cc:
ech.com> Subject: [Vantage] Joining Tables

11/07/00
03:31 PM
Please
respond to
vantage






Hello all,

I need some help with a Report Builder, I have a report that contains
Jobnum, required date, required quantity and partnum. The problem is that
I
only found Reqdate under JobMtl and nothing else. Can anyone tell me where
else to find ReqDate besides JobMtl so I can join the tables?!? Or Am I
missing something?!?!

Jobnum=Jobhead, JobAsmbl
ReqDate= ? ?
ReqQuantity= JobAsmbl, JobMtl

Any help would be greatly appreciated.

Thanks

Marites Marlar
MIS Department
SPS Non-Ferrous
(702) 262-9922 ext. 118




We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link
above will work the next time you try it.)




______________________________________________________________________


This document should only be read by those
persons to whom it is addressed and is not intended to be relied upon by
any person without subsequent written confirmation of its contents.
Accordingly, PRECISION MACHINE AND MANUFACTURING COMPANY disclaims all
responsibility and accepts no liability, including in negligence, for the
consequences for any person acting, or refraining from acting, on such
information prior to the receipt by those persons of subsequent written
confirmation.

If you have received this E-mail / Fax
message in error, please notify PRECISION MACHINE AND MANUFACTURING COMPANY
immediately by telephone. Please also destroy and delete the message.

Contact:
By Phone: Systems
Administrator at (515)-733-5181
By Email:
sysadmin@...

Any form of reproduction, dissemination,
copying, disclosure, modification, distribution and/or publication of this
E-mail / Fax message is strictly prohibited.
4
Marites,

You should not join the req date to anything. That field should not be one
of your joins at all. If you explain what information you are trying to get
at, I can try to explain the proper joins to you.

Sarah Vareschi
Information Systems Engineer
NyproMold, Inc.
33 School Street
Clinton, MA 01510
sarah.vareschi@...

------------------------------------

Hello all,

I need some help with a Report Builder, I have a report that contains
Jobnum, required date, required quantity and partnum. The problem is that I
only found Reqdate under JobMtl and nothing else. Can anyone tell me where
else to find ReqDate besides JobMtl so I can join the tables?!? Or Am I
missing something?!?!
Jobnum=Jobhead, JobAsmbl
ReqDate= ? ?
ReqQuantity= JobAsmbl, JobMtl

Any help would be greatly appreciated.
Thanks
Marites Marlar
MIS Department
SPS Non-Ferrous
(702) 262-9922 ext. 118
5
If you are looking to get the sales order requested date then link back to
JobProd and then to OrderRel. If you are looking for the due date of the
job then that will be in JobHead.

Ted Kitch
tedkitch@...

On Tue, 7 Nov 2000 13:31:47 -0800, vantage@egroups.com wrote:

> Hello all,
>
> I need some help with a Report Builder, I have a report that contains
> Jobnum, required date, required quantity and partnum. The problem is
that I
> only found Reqdate under JobMtl and nothing else. Can anyone tell me
where
> else to find ReqDate besides JobMtl so I can join the tables?!? Or Am I
> missing something?!?!
>
> Jobnum=Jobhead, JobAsmbl
> ReqDate= ? ?
> ReqQuantity= JobAsmbl, JobMtl
>
> Any help would be greatly appreciated.
>
> Thanks
>
> Marites Marlar
> MIS Department
> SPS Non-Ferrous
> (702) 262-9922 ext. 118
>
>


Ted Kitch
tedkitch@...





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html