Table Relationship

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: Fri, 31 Jul 1998 04:21:57 GMT
Message-ID: <35c93ffb.15154051@172.16.7.252>

Hello,
How can I solve the problem???

I have 2 tables,TABLE1 and TABLE2

TABLE1 			TABLE2
----------------------------------         ------------------------
ORD_NO     CHAR(12)           ORD_NO      CHAR(12)
GROUP_A  CHAR(2)              ORD_NAM  CHAR(20)
GROUP_B  CHAR(2)              ACCT_NO    CHAR(8)
GROUP_C  CHAR(2)              QTY                NUMBER(11,4)
COLOR        CHAR(3)                  :::::::::
PK:ORD_NO                              PK:ORD_NO

TABLE1 is master,and TABLE2 is detail of TABLE1, so the ORD_NO must exist in TABLE1 & TABLE2 But when I add a foreign key ORD_NO reference TABLE1 (ORD_NO), it always failure.
How could I create the relationship between TABLE1 & TABLE2? Please Cc to: violin.hsiao_at_mail.pouchen.com.tw,Thank you so much :) Received on Thu Jul 30 1998 - 23:21:57 CDT