🚀 go-pugleaf

This is a multi-part message in MIME format.
--------------004F9F4320D4920ABC0EFB19
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit




> =============================================================
> Peter,
>
> Sorry for the delay in my reply. I did respond a few days ago to let you
> know that I had been away on holiday, but this message bounced back to
> me --- "address not found". So, I went back to the newsgroup and got
> your other address there.
>
> As for your problem...
>
> I think that you have a few options here. If I understand you correctly,
> you wish to use functie.wfm to enter workers and their tasks. At the
> same time, you wish to enter the name of their supervisor. Names of
> supervisors are stored in the Pesoon.dbf.
>
> The easiest way, I think, would be to have a ComboBox for the
> supervisors. You can make the DataSource of the ComboBox "FILE
> persoon.dbf". If this creates too many names, you could have a temporary
> file (say "supervis.dbf") that is created when the form opens.
> Supervis.dbf could be a copy of persoon.dbf, except that you would only
> select the supervisor names for it (assuming you have a field or some
> way in your Persoon.dbf to distinguish supervisors from
> non-supervisors). In fact, you could make Supervis.dbf a very simple
> file of just names. However, remember that if someone adds a new
> supervisor after Functie.wfm has been opened, the new name will not be
> in Supervis.dbf.
>
> The other choice is more complicated. It would be to have a Entryfield
> for the supervisor name and a button next to it. When the user clicks on
> the button, you could open a separate form to search the Persoon.dbf.
> When this second form is closed, it could return the selected name to
> the Entryfield. The benefit of this extra work is that if you have a
> networked environment where different people are entering names, the
> list of supervisors will always be up-to-date, while in my first
> suggestion it would be only up to the point in time the Functie.wfm was
> opened. As well, this method would let you have a more powerful search
> and you can display details besides the supervisors' names to help users
> decide to which supervisor to assign a new worker.
>
> I hope this points you in the right direction.
>
> As an aside, it is better to post everything to the newsgroup unless it
> is off topic. This way, other users can read your problem, see your
> sample code and offer their answers. At the same time, still others can
> read the responses and learn something themselves. Thus, why I have
> posted and mailed this response. :-)
>
> Geoff Wass
> Kuala Lumpur, Malaysia
>
> Triumph is in the first syllable.
> =============================================================

--------------004F9F4320D4920ABC0EFB19
Content-Type: message/rfc822
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Received: from out1.ibm.net [165.87.194.252] by in5.ibm.net id 891161734.57442-18 ; Sun, 29 Mar 1998 08:55:34 +0000
Received: from localhost (localhost) by out1.ibm.net (8.8.5/8.6.9) with internal id IAA08430; Sun, 29 Mar 1998 08:58:33 GMT
Date: Sun, 29 Mar 1998 08:58:33 GMT
From: Mail Delivery Subsystem <MAILER-DAEMON@ibm.net>
Subject: Returned mail: User unknown
Message-Id: <199803290858.IAA08430@out1.ibm.net>
To: <gswass@IBM.NET>
MIME-Version: 1.0
Content-Type: multipart/report; report-type=delivery-status;
	boundary="IAA08430.891161913/out1.ibm.net"
Auto-Submitted: auto-generated (failure)

This is a MIME-encapsulated message

--IAA08430.891161913/out1.ibm.net

The original message was received at Sun, 29 Mar 1998 08:26:38 GMT
from slip202-135-32-94.kl.my.ibm.net [202.135.32.94]

   ----- The following addresses had permanent fatal errors -----
<borland.public.vdbase.data.sql@ibm.net>

   ----- Transcript of session follows -----
... while talking to in5.ibm.net.:
>>> RCPT To:<borland.public.vdbase.data.sql@IBM.NET>
<<< 550 <borland.public.vdbase.data.sql@IBM.NET>... Not a local address
550 <borland.public.vdbase.data.sql@ibm.net>... User unknown

--IAA08430.891161913/out1.ibm.net
Content-Type: message/delivery-status

Reporting-MTA: dns; out1.ibm.net
Arrival-Date: Sun, 29 Mar 1998 08:26:38 GMT

Final-Recipient: rfc822; borland.public.vdbase.data.sql@IBM.NET
Action: failed
Status: 2.0.0
Remote-MTA: dns; in5.ibm.net
Diagnostic-Code: smtp; 250 891161734.57442-16 Message accepted for delivery
Last-Attempt-Date: Sun, 29 Mar 1998 08:58:33 GMT

--IAA08430.891161913/out1.ibm.net
Content-Type: message/rfc822

Return-Path: gswass@ibm.net
Received: from ibm.net (slip202-135-32-94.kl.my.ibm.net [202.135.32.94]) by out1.ibm.net (8.8.5/8.6.9) with ESMTP id IAA13248; Sun, 29 Mar 1998 08:26:38 GMT
Message-ID: <351E064E.BF40FAE1@ibm.net>
Date: Sun, 29 Mar 1998 16:29:02 +0800
From: Geoff Wass <gswass@IBM.NET>
Organization: Noordindarus Consultancy Sdn. Bhd.
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: annazkh3@wxs.nl, borland.public.vdbase.data.sql@IBM.NET
Subject: Re: Query doesn't show fields
References: <35104305.4A18@worldaccess.nl> <3511CCFF.9C4DBDE4@ibm.net> <3515340E.493@wxs.nl>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

=============================================================
Peter,

Sorry for the delay in my reply. I did respond a few days ago to let you
know that I had been away on holiday, but this message bounced back to
me --- "address not found". So, I went back to the newsgroup and got
your other address there.

As for your problem...

I think that you have a few options here. If I understand you correctly,
you wish to use functie.wfm to enter workers and their tasks. At the
same time, you wish to enter the name of their supervisor. Names of
supervisors are stored in the Pesoon.dbf.

The easiest way, I think, would be to have a ComboBox for the
supervisors. You can make the DataSource of the ComboBox "FILE
persoon.dbf". If this creates too many names, you could have a temporary
file (say "supervis.dbf") that is created when the form opens.
Supervis.dbf could be a copy of persoon.dbf, except that you would only
select the supervisor names for it (assuming you have a field or some
way in your Persoon.dbf to distinguish supervisors from
non-supervisors). In fact, you could make Supervis.dbf a very simple
file of just names. However, remember that if someone adds a new
supervisor after Functie.wfm has been opened, the new name will not be
in Supervis.dbf.

The other choice is more complicated. It would be to have a Entryfield
for the supervisor name and a button next to it. When the user clicks on
the button, you could open a separate form to search the Persoon.dbf.
When this second form is closed, it could return the selected name to
the Entryfield. The benefit of this extra work is that if you have a
networked environment where different people are entering names, the
list of supervisors will always be up-to-date, while in my first
suggestion it would be only up to the point in time the Functie.wfm was
opened. As well, this method would let you have a more powerful search
and you can display details besides the supervisors' names to help users
decide to which supervisor to assign a new worker.

I hope this points you in the right direction.

As an aside, it is better to post everything to the newsgroup unless it
is off topic. This way, other users can read your problem, see your
sample code and offer their answers. At the same time, still others can
read the responses and learn something themselves. Thus, why I have
posted and mailed this response. :-)


Geoff Wass
Kuala Lumpur, Malaysia




Triumph is in the first syllable.
=============================================================



--IAA08430.891161913/out1.ibm.net--



--------------004F9F4320D4920ABC0EFB19--