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.
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
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…
Conversion Steps for merging and consolidating separate Filemaker files
The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…