Hi John:
Thanks for your response...

Look this is the situation...
I have two words because I'm working with COBOL program database and Cobol
is using those particulars letters. IM (Item Number), ID (Identification), RQ
(Requirements), TX (Transaction Number), etc.

This is the list that I have on my TABLES: ID - IM- IM1- ML-MO_STAT - MOS -
MOS1 - OP -RQ - TX... All of them are LINK Tables Except the MO_Stat because
is a Table.
I have three different forms 1)the ID,2) Transaction and 3) Requirements.  
The first two are working correctly.  I’m having problems with the
Requirements. In design view, I have a trust relationship built among: IM,
RQ, OP, MOS, MO_STAT, IM1.
The Im_key is pointing to RQ_Imkey, Im1 (Im_key) is pointing to the
MOS_Imkey, MO_Status is pointing to MOS_Status.
In RQ_satus and OP_Status, I have criteria of “<>C”.  
In Im_Key I have a Forms formula pointing to the FORM and the name of the
label under FORM.

The Item number is typing into a TEXTBox. and this one look for the correct
number with his information. for example if I type R12345 I need to know the
complete information about that number,    
C78170C     R  0078999         78     14.07    2    0    20    3/20/2006    R648944              
           2    3/21/2006    3/20/2006
Where this information is corresponding to the Item Number R12345. But in
this case this information is repeating 4 and 8 times in a duplication issue.

Ok This is the SQL View of this program.

SELECT IM1.IM_KEY, MO_STAT.MO_DESC_STATUS, RQ.RQ_STATUS, MOS.MOS_JOB,
MOS.MOS_LOT, RQ.RQ_EST_COST, RQ.RQ_QTY_REQ, RQ.RQ_QTY_ISS, RQ.RQ_OP_NUM,
RQ.RQ_DATE_REQ, IM.IM_KEY, [RQ_QTY_REQ]-[RQ_QTY_ISS] AS BAL_REQ,
MOS.MOS_WANTDATE, MOS.MOS_DATE_REL
FROM PD, ((IM INNER JOIN ((IM1 INNER JOIN (RQ INNER JOIN MOS ON
(RQ.RQ_MOSSEQNUM = MOS.MOS_SEQNUM1) AND (RQ.RQ_MOSTYPE = MOS.MOS_TYPE) AND
(RQ.RQ_MOSJOB = MOS.MOS_JOB) AND (RQ.RQ_MOSLOT = MOS.MOS_LOT)) ON IM1.IM_KEY
= MOS.MOS_IMKEY) INNER JOIN OP ON (RQ.RQ_MOSTYPE = OP.OP_MOSTYPE) AND
(RQ.RQ_MOSJOB = OP.OP_MOSJOB) AND (RQ.RQ_MOSLOT = OP.OP_MOSLOT) AND
(RQ.RQ_MOSSEQNUM = OP.OP_MOSSEQNUM)) ON IM.IM_KEY = RQ.RQ_IMKEY) INNER JOIN
MO_STAT ON MOS.MOS_STATUS = MO_STAT.MO_STATUS) INNER JOIN OL ON
MOS.MOS_OLPHKEY = OL.OL_PHKEY
WHERE (((RQ.RQ_STATUS)<>"C") AND
((IM.IM_KEY)=[Forms]![PurchinfoFRM]![ItemNumber]) AND
(([RQ_QTY_REQ]-[RQ_QTY_ISS])>0) AND ((OP.OP_STATUS)<>"C"));

Your help will be greatly appreciated.

I hope to be hearing from you soon.

Robert