Thanks to all who replied, I did manage through trial & error to figure this out myself. Talking to you guys in the States is like calling Mars, long lag time. (actually calling Mars is only about 23 minutes round trip)

As for the pubs. Yes, fortunately they do close. If they didn't, Australia would grind to a halt as 60% of the workforce would be totally blotto (and that includes the females!) :-)

Regards,
David Sloan
IT Manager
Entech Integrated Technologies

Phone: +61 8 8245 6789
Fax: +61 8 8245 6788
Direct Phone: +61 8 8245 6732
Postal Address: PO Box 1141, Marleston SA 5033
Site Address: 37 Belford Ave, Devon Pk SA 5008
================================
email: dsloan@...
Web: http://www.entechgroup.net
================================

----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Sent: Wednesday, May 16, 2001 10:39 PM
Subject: RE: [Vantage] Indirect Labour report

At 07:49 AM 5/16/2001 -0500, you wrote:
>Wayne,
>Employee number links to EmpID in EmpBasic table.
>Warren R. Eddy

That was just my reply; David was the original poster. Oops, just noticed
that I put an extraneous "dot" in EmployeeNum. Ah well... he'll figure it
out ok tomorrow. Looks like David is on Aussie time, so he's probably out
closing down the bars or something now. Or do they close there ?!

-Wayne

To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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

Hi all,
I am trying to write a report in CRW 7 for Vantage 4, and need to link LaborDtl.employeeNum to the employee basic table. All I have in the labordtl table is EmployeeNum which doesn't seem to link to anything except the LaborHed table.

I am trying to show employee ID, employee name, total indirect labour for that employee per workcentre in a set period.
Can anyone help, or am I barking up the wrong table?

Regards,
David Sloan
IT Manager
Entech Integrated Technologies

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

At 03:36 PM 5/16/2001 +0930, you wrote:

>I am trying to write a report in CRW 7 for Vantage 4, and need to link
>LaborDtl.employeeNum to the employee basic table. All I have in the
>labordtl table is EmployeeNum which doesn't seem to link to anything
>except the LaborHed

Link LaborDtl.Employee.Num to EmpBasic.EmpID Someone bunged things up,
and got the names inconsistent. But it'll work.

-WC

Wayne,
Employee number links to EmpID in EmpBasic table.

Warren R. Eddy
Information Services Manager
National Tube Form, LLC
Phone: (219) 478-2363 ext 217
Fax: (219) 478-1043
Warren.Eddy@...

-----Original Message-----
From: Wayne Cox [mailto:wmc@...]
Sent: Wednesday, May 16, 2001 7:03 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Indirect Labour report

At 03:36 PM 5/16/2001 +0930, you wrote:

>I am trying to write a report in CRW 7 for Vantage 4, and need to link
>LaborDtl.employeeNum to the employee basic table. All I have in the
>labordtl table is EmployeeNum which doesn't seem to link to anything
>except the LaborHed

Link LaborDtl.Employee.Num to EmpBasic.EmpID Someone bunged things up,
and got the names inconsistent. But it'll work.

-WC

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

At 07:49 AM 5/16/2001 -0500, you wrote:

>Wayne,
>Employee number links to EmpID in EmpBasic table.
>Warren R. Eddy

That was just my reply; David was the original poster. Oops, just noticed
that I put an extraneous "dot" in EmployeeNum. Ah well... he'll figure it
out ok tomorrow. Looks like David is on Aussie time, so he's probably out
closing down the bars or something now. Or do they close there ?!

-Wayne

Yep, already sussed this out, thanks. It helps when the fields which are supposed to be linkable are at least the same name! :-)

Regards,
David Sloan
IT Manager
Entech Integrated Technologies

----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Sent: Wednesday, May 16, 2001 9:33 PM
Subject: Re: [Vantage] Indirect Labour report

At 03:36 PM 5/16/2001 +0930, you wrote:
>I am trying to write a report in CRW 7 for Vantage 4, and need to link
>LaborDtl.employeeNum to the employee basic table. All I have in the
>labordtl table is EmployeeNum which doesn't seem to link to anything
>except the LaborHed

Link LaborDtl.Employee.Num to EmpBasic.EmpID Someone bunged things up,
and got the names inconsistent. But it'll work.

-WC

To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

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