Script to perform find and replace
I have a layout that contains fields from 2 different tables. One of those tables is from an ODBC connection back to our eccommerce site. It contains password and user data for logging into our website. I can change the password field in this filemaker table and it updates the password info on the site so that appears to be working fine. The second table is our customer data information in filemaker. We also have a password field in it that we would like employees to be able to update and it automatically update the password field in our other table with a script...I've tried find and replace with no luck and also looked at replace field contents....What is the best way to do this? Thanks.