No, you use the ALTER TABLE COMMAND ALTER TABLE TimeCards ADD FOREIGN KEY (EmplNum) REFERENCES Employees
You must have a compatible primary key in Employees "Fogelson, Steve" <[EMAIL PROTECTED]> wrote: >Using R:Base 6.5+ > >Can you use CREATE INDEX to create a foreign key. If so, can you provide an >example. > >Thanks > >Steve Fogelson >Internet Commerce Solutions > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
