Find - "No records match this find criteria" fouls my script -- Can anyone help??
I tried to write a script that says look at the first record in the parts database, take that part number and go to the labor/parts DBF and find how many of those parts were used during the first quarter of 2010, take that summary total number and go back to the parts database and put it in the Qtr1 2010 field, and then loop through all the records. It works ok if the part was used but if it wasn't and the "No records match....." comes up it fouls up the whole thing and actually puts the part number in my Qtr1 2010 field instead of a zero. Tried everything I know--which isn't a lot--but can't make it work.
I WOULD APPRECIATE ANY IDEAS ANYONE MAY HAVE.
THANK YOU SO MUCH.