>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
It should be if seek(forms.account,"form_temp", "account_no"), IOW, the second parameter should be a name of the table, which should be searched (in quotes) and the last parameter should be an tag name in the table form_temp. If the tag name is account, it should be "account". Check the Help file on seek() function.
If it's not broken, fix it until it is.
My Blog