Script to find record and paste data
I have a script that I wrote about 15 years ago, and it's stopped working. I can't figure out how to fix it.
I have two databases - an invoice database and a product database.
I need to copy an item number from the invoice database, find that item in the product database, and then enter the current date in a "sold date" field in the product database.
It seems like this should be simple, but I can't figure out how to script a find based on the copied value of the item number.
FM Pro 10, Macintosh system. Thanks in advance - this is driving me crazy.