Quick question, pardon the pun

[Michael Lee]

I'm not sure that you can do this. Without the PRIMARY file there is no
transaction. You can do a GET in the POSTPATH to see if your GET in the FIND
will work or not, but I don't think doing a GET on another file type will work
if there is no PRIMARY record (even if the GET on the PRIMARY is OPTIONAL). Try
it out and see if it works. If it does-great. Otherwise I would suggest calling
another screen that has your designer file as a PRIMARY.

As well I'm unsure of the relationship between the DESIGNER file and the
PRIMARY file. Does the DESIGNER file contain the EMPLOYEE-NO? If so you could
do the GETs in the POSTPATH and store the EMPLOYEE-NO into a TEMP item and GET
the PRIMARY using the temp.

Hope this helps.

Michael Lee
MCL Systems Inc.

"Gassett, Chris" wrote:

> If the find on the primary file fails how do I search on the designer file
> using quick?  Main goal is to find on employeeno from worker_comp, if that
> fails then search via surname from designer table.  We are using PH ver.
> 7.33 on HP.
>
> SCREEN TEMP
> FILE WORKER_COMP PRIMARY
> FILE EMPLOYEES   DESIGNER
> ALIGN (1,4,21)(41,44,61)
> FIELD EMPLOYEENO OF WORKER_COMP REQUIRED NOCHANGE &
>       NULL VALUE NOT ALLOWED
> FIELD SURNAME    OF EMPLOYEES
> FIELD GIVEN_NAME OF EMPLOYEES DISPLAY
> PROCEDURE ENTRY
> BEGIN
>   ACCEPT EMPLOYEENO OF WORKER_COMP
> END
> PROCEDURE PATH
> BEGIN
>   REQUEST EMPLOYEENO OF WORKER_COMP
>   IF PROMPTOK
>     THEN LET PATH = 1
>   IF PATH = 0
>     THEN BEGIN
>       REQUEST SURNAME OF EMPLOYEES
>       IF PROMPTOK
>       THEN LET PATH = 2
>     END
>   IF PATH = 0
>     THEN BEGIN
>       LET PATH = 3
>     END
> END
> PROCEDURE FIND
> BEGIN
>   IF PATH = 1
>     THEN GET WORKER_COMP VIA EMPLOYEENO
>   IF PATH = 2
>     THEN GET EMPLOYEES VIA EMPLOYEENO
>   IF PATH = 3
>     THEN GET WORKER_COMP SEQUENTIAL
> END
> BUILD
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.