?
Solved

Update a field for all records in a table

Posted on 2014-10-08
2
Medium Priority
?
164 Views
Last Modified: 2014-10-09
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.
0
Comment
Question by:akb
2 Comments
 
LVL 4

Accepted Solution

by:
historychef earned 2000 total points
ID: 40370192
You can do a "Replace Field Contents" on that field (it's on the Records menu). Start by showing all records in the table. Select in the Warning field, then select "Replace Field Contents", then select "Replace with calculated result" with the following calculation:

If ( Twomonthsdue > 0; 4; 1 )

It will all be done in a few seconds.
0
 
LVL 13

Author Comment

by:akb
ID: 40370279
Thanks historychef. You are a legend!
I had spotted that option in the menus but it was greyed out. Soon worked out that I needed to have the field selected, then it all worked like a dream.
Then I read your reply again and realised that you told me "Select in the Warning field" - DOH!
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question