I have File Maker Pro 8.5.
I have a table called Clients.
There is a field called Warning - this is a radio button and another field called Twomonthsdue.
For all records in the table I want to do the following:
- Set Warning to 1
- If Twomonthsdue>0 then set warning to 4
This is a one off requirement. I only need to do this once in order to tidy up some incorrect data in the database.
This would be easy for me if it was dbase but I'm very green when it comes to File Maker so clear instructions would be appreciated.