>I have two tables that I have linked with key+date/time field. I added the date/time field because on occasions the key may be duplicated and that is valid for this app.
>
>So now I do a sql select statement on key and date/time field and it doesn't work! I can manually link and browse the matches in the command window so I know the key+date/time link is valid. Why doesn't sql select match them????
See this
message and its associated thread for some information on this.
BTW, I saw where someone posted some SQL Server T-SQL code for this. Are you using SQL Server or VFP? You mention the Command Window so I am guessing you are using VFP.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao