>Hi there!
>
>Thank you for responding to my question. I have been having a time to get this right. I tried your code, and I keep on blowing a ALIAS is not FOUND error. Could you happen to elaborate for me the first line:
>
>IF SEEK( table1.account_no, table2, {tagname} )
>
>I got the table1.account_no part = Table1.{fieldname)
>
>I think I keep on blowing on the table 2 part.
>
>Both of the tables have an ascending index on account_no. I tried variations of the code:
>
>IF SEEK( forms.account, form_temp.account, account)
>
>IF SEEK( forms.account, form_temp, account)
>
>What am i doing wrong?
>
>Thanks again!
>
>Nathan
The table2 and tag names should be in quotes:
IF SEEK( forms.account, "form_temp", "account")
Try that.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.