**
The report I have to make should include all assets, whether they have components or existing warranty data. Basically what I need are the list of all assets, the components related to the assets, the warranty expiration date of the assets if there are any and the warranty expiration date of the components related to the assets if there are any.

------------------
Consider using inner join forms for the two join forms used to construct
the fifth join. Ask yourself if there is any reason why you would use
an outer join. Why would you want to include information regarding as
asset/component for which no corresponding contract/warranty exists?

Axton

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto: ARSLIST@ARSLIST.ORG] On Behalf Of Jenny Singson
Sent: Wednesday, August 06, 2003 10:04 PM
To: ARSLIST@ARSLIST.ORG
Subject: AR Error 121

Hello,
I am creating join forms for use in a report that would display a list
of
main assets, their related components and the warranty expiration date
of
both the main assets and components (if there any).
The join forms I created are the following:

First Join Form: Primary form is AST:Asset and Secondary Form is
TCO:Costs. The join type is outer and the join criteria is the Entry-ID
field from the AST:Asset form and the AssetCompEID field from the
TCO:Costs form. I get no errors when I retrieve data using this form.

Second Join Form: Primary form is the first join form created
(AST:Asset and TCO:Costs) and Secondary form is AST:AssetWarranty. The
join type is outer and the join criteria is the ContractEID field from
the
first join form and the Entry-ID field from the AST:AssetWarranty form.
I
get no errors when I retrieve data using this form.

Third Join Form: Primary form is AST:Component and Secondary Form is
TCO:Costs. The join type is outer and the join criteria is the Entry-ID
field from the AST:Component form and the AssetCompEID field from the
TCO:Costs form. I get no errors when I retrieve data using this form.

Fourth Join Form: Primary form is the third join form created
(AST:Component and TCO:Costs) and Secondary form is AST:AssetWarranty.
The
join type is outer and the join criteria is the ContractEID field from
the
third join form and the Entry-ID field from the AST:AssetWarranty form.
I
get no errors when I retrieve data using this form.

Fifth Join Form: The primary form is the second join form which I
described above and the secondary form is the fourth join form which I
described above. The join type is outer and the join criteria is the
Entry-
ID (the Entry-ID field of the asset record) field of the second join
form
and the Main Asset EID field of the fourth join form. If the data
involved
is main asset with no related component, I get the error, ARERR [121]
Error
with an entry in the Entry ID list : [Name of Fourth Join Form].

Can anyone help me out?

Thanks,
Jenny



UNSUBSCRIBE or access ARSList Archives at http://www.ARSLIST.org
(Support: mailto: support@arslist.org ) ARSList is hosted by QMX SUPPORT
SERVICES at www.QMXS.com


This posting was submitted via the Web interface