Help Required

[Kevin O'Sullivan]

Hi all,

I am having major difficulty in getting my head around a problem I have.

Temp T-POREQST Char*10

FILEA - KSAM - consists of only two fields, POREQST and PO
where POREQST is x(30) and a repeating key, whilst PO is x(10)

FILEB - IMAGE MASTER - contains many fields, two of which are POREQST and PO
where PO is x(10) and a repeating key, whilst POREQST is x(30)

FILEC - IMAGE - DETAIL - occurs 6 and contains many fields, one of which is PO
where PO is x(10) and a repeating key

I need to perform a Find on FILEA via POREQST using T-POREQST, if the record
is found, then get FILEB via PO of FILEA and FILEC via PO of FILEA

If no record is found in FILEA, I want to sequentially read down FILEB,
selecting where POREQST of FILEB = T-POREQST, then get FILEC via PO using PO
of FILEB

In short, the KSAM file holds a daily xref of POREQST and PO, whereas the
IMAGE MASTER only allows sequential searches via the POREQST field. So, the
KSAM will allow keyed retrieval for all data prior to the next 'Update the
Ksam xref' job.

I hope I haven't created too much confusion, and that someone can shed some
light on my dilemma.

Of course, it may be straight forward......

Many thanks,,

Kevin

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Kevin O'Sullivan                        Cosworth Racing Limited,  -
- Systems Administrator                   The Octagon,              -
- Business Information Systems            St James Mill Road,       -
-                                         Northampton, England,     -
-                                         NN5 5RA.                  -
-                                         Tel: +44 (0) 1604 598488  -
- mailto:kosullivan@cosworth-racing.co.uk Fax: +44 (0) 1604 598506  -
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
The views expressed above are mine entirely and in no way represent
those of my employer.



********************************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the email administrator - mailadmin@cosworth-racing.co.uk
********************************************************************************