Actually each contact is already unique only it's by name and not number.
Duey From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Eyring Sent: Wednesday, October 08, 2008 10:53 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SQL Question Duey You might consider restructuring your contact table so each contact is unique while tracking each contactdate. Table structure might be; CntId INTEGER AUTONUM CustId Integer (New) or something similar CntNme TEXT 10 CntDte DATE So your data would look something like this; 1,101,Dave,01/25/2008 2,102,Jack,05/09/1981 3,102,Jack,10/09/1985 4,101,Dave,01/01/1980 5,103,Sam,06/17/2004 This would create the 1 to 1 relationship Bill suggested making it easier to do data retrieval and queries. My .02. Bill Eyring ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Heffelfinger, Duane Sent: Wednesday, October 08, 2008 10:01 AM To: RBASE-L Mailing List Subject: [RBASE-L] - SQL Question I suspect this is a very easy SQL statement that I just can't think of today. I have a contact table with the following columns. CntId INTEGER AUTONUM CntNme TEXT 10 CntDte DATE And the following rows: 1,Dave,01/25/2008 2,Jack,05/09/1981 3,Jack,10/09/1985 4,Dave,01/01/1980 5,Sam,06/17/2004 I want an sql statement that produces the contact id for the most current contact of each individual. The result should be: CntId +++++ 1 3 5 Thanks for any ideas. Duey P.S. Hope we're playing golf after the conference on Monday?
