Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bert Murillo
  Where is Bert Murillo?
 Valenzuela
 Philippines
 Bert Murillo
 To: Rob Vleeschhouwer
  Where is Rob Vleeschhouwer?
 Leeuwarden
 Netherlands
 Rob Vleeschhouwer
 Tags
Subject: RE: Primary key
Thread ID: 104515 Message ID: 104540 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, August 17, 2006 12:45:03 PM         
   


> > > Hi,
> > >
> > > Is it possible to combine two fields for a primary key.
> > > In a orderform an articlenumber can be used twice, or more.
> > > So I will combine it with the field amount(m2). Making simple this two fields as primary key doesn't work.
> > >
> > > Rob

> >
> >
> > If your using SQL Database, just select the fields you want to set as primary keys..

>
> I have tried that, but it doesn't work. Don't know why.


Be sure that there's no duplicate records when doing it

ENTIRE THREAD

Primary key Posted by Rob @ 8/17/2006 11:15:56 AM
RE: Primary key Posted by Bert Murillo @ 8/17/2006 11:27:43 AM
RE: Primary key Posted by Rob @ 8/17/2006 12:01:10 PM
RE: Primary key Posted by Bert Murillo @ 8/17/2006 12:45:03 PM
RE: Primary key Posted by Borislav Borissov @ 8/17/2006 11:36:23 AM
RE: Primary key Posted by Rob @ 8/17/2006 11:59:13 AM
RE: Primary key Posted by Borislav Borissov @ 8/17/2006 12:36:46 PM
RE: Primary key Posted by Marcia Akins @ 8/17/2006 12:29:32 PM
RE: Primary key Posted by Rob @ 8/17/2006 2:12:04 PM
RE: Primary key Posted by Borislav Borissov @ 8/17/2006 2:22:12 PM
RE: Primary key Posted by Koen Piller @ 8/17/2006 12:56:59 PM