>I have a form that displays company address info in text boxes then processes that company does in a grid. I have add/edit buttons for each part of the form (address and process info). Everything seems to be working correctly until I need to verify the process that is being added does not already exist for that company. I am just not sure what is wrong with my code. No matter what the process is added and no error message was given. I am using VFP 7. Kudus to whoever helps me with this dilemma.
>
>IF EMPTY( l_prcode )
> MESSAGEBOX( 'Product Code is required.', 48, 'Please fix your entry' )
> RETURN .F.
>ELSE
> SEEK l_cocode + l_prcode
> IF FOUND()
> MESSAGEBOX( 'Product Code is required.', 48, 'Product does not exist' )
> RETURN .F.
> ELSE
> MESSAGEBOX( 'Listing has been added.' )
> RETURN .T.
> ENDIF
>ENDIF

Julie,
What are l_prcode, l_cocode etc ? Memvar or fieldname or both ?
What is the selected table alias when you call this ?
Buffering - row,table or none ?
Where/When this is called - before/after tableupdate, tableupdate() call syntax, moved off the row ? etc...
Cetin